DSXchange

So Which Country (Home or work) you are planning to put in country field (Output) if they can be different for same Emp ID.[/quote] hi , please find my source data format MY SOURCE DATA IS EMPID,LOC,PHONE,COUNTRY 1,Home,1234,IND 2,Home,0345,IND 3,Work,0234,JAP 4,Work,1357,USA 1,Work,0012,IND 4,Home,...

chandra4u wrote:Can I combine server job and parallel job in one sequence. Have anybody tried that. I just want to know by combining these two whether we can get a good performance.

yes we can use both server an parallel jobs in a job sequence

Just to clarify: You're stating that a specific ID value may be associated with more than one COUNTRY? (In your example data, each ID has only a single COUNTRY associated to it) yes, here id means it's an emp_id field,so in each COUNTRY n number of emp_id's are available.COUNTRY it's not an key field

ray.wurlod wrote:Yes, don't keep asking the same question over and over.


We're trying to get to the right answer in your other thread. ...

Sorry ray

HI ALL ,

MY SOURCE DATA IS

EMPID,LOC,PHONE,COUNTRY
1,Home,1234,IND
2,Home,0345,IND
3,Work,0234,JAP
4,Work,1357,USA
1,Work,0012,IND
4,Home,5678,USA

I NEED AN OUT PUT SOME THING LIKE

EMPID,HOME_PHONE,WORK_PHONE,COUNTRY
1,1234,0012,IND
2,0345,NULL,IND
3,NULL,0234,JAP



ANY SUGGESTIONS PLEASE???

ray.wurlod wrote:Will the country ever be different for the same value of ID? ...

yes ray country code would be different .different id's having same country code.

hi all, could you please share your thoughts for job design of the following reqirement mine source data is ID,LOC,PHONE,COUNTRY 1,Home,1234,IND 1,Work,0012,IND 2,Home,0345,AUS 3,Work,0234,JAP 4,Work,1357,USA 4,Home,5678,USA i need an out put like ID,HOME_PHONE,WORK_PHONE,COUNTRY 1,1234,0012,IND 2,0...

dhanashreepanse wrote:pls ignore that repy....that's from Director...not Admin

hi
thanks for your respond,is there any way relese locks from asminstrator

hi ,

any one please suggest me how to release locks from datastage administrator comnd tools.

what is the difference between server jobs and parllel jobs there is a lot of differences between server and parallel jobs. especially parallel jobs supports partioning,we can do in server jobs also by using some stages like link partitiner and collecter.but in parallel each and every stage support...

what is the difference between server jobs and parllel jobs there is a lot of differences between server and parallel jobs. especially parallel jobs supports partioning,we can do in server jobs also by using some stages like link partitiner and collecter.but in parallel each and every stage support...

Be more intuitive about your search criteria. An exact match search for "LONG data" returned 33 matches. ... THANKS RAY, FINALLY I GOT A SOLUTION,I JUST DEFINE THE DATATYPE AS VARBINARY AND LENGHT AS 1000000 WHILE EXTRACTING THE DATA FROM OCI8 AFTER I CHANGED THE DATATYPE AS VARCHAR.IT WO...

ray.wurlod wrote:Totally wrong. The data viewer can display data from almost all sources (one exception is Lookup File Set). ...

hi ray,

i think that is data browser not a data viewer.

ray.wurlod wrote:Search ...

hi ray.wurlod,

i searched in the dsxchange forums to get the solution for my issue.i haven't yet get.

when iam executing (dsjob -ljobs projectname) its not working m getting warning like dsjob not found , i have tried this in opt/IBM/datastage , how to run and where to run dsjob command just try where is your data stage engine was installed.by default opt/ascential/datastage/pxengine/bin once you s...