how to achieve this output ?

Two Input columns(ID & Name) -
ID | Name
1 | Jack
1 | Kara

In output there should be only 1 column which will be populated as -
1,Jack
1,Kara


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Stage Interview Questions

6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment

3 Answers   TCS,


How many Nodes configuration file you used in your last project?

1 Answers  


what is the function in Transformer stage can act as Rank function in Oracle

1 Answers   Reliance,


Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?

1 Answers   TCS,


How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?

3 Answers  






hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.

4 Answers   IBM,


What is difference between join, merge and lookup stage?

0 Answers  


what is repositery?

0 Answers   IBM,


Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me

1 Answers  


what is normalization and denormalization

2 Answers   CTS,


Can you implement SCD2 using join, transformer and funnel stage?

0 Answers   Cognizant,


in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....

4 Answers  


Categories