in datastage scenario this is sourec data i want this traget? tell me please?

source target
------- -------
Mohan,Prasad,Naresh Mohan
Prasad
Naresh



in datastage scenario this is sourec data i want this traget? tell me please? source ..

Answer / datastage4you

Use Pivot stage

Thanks
www.datagenx.net

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Data Stage Interview Questions

Explain Quality stage?

0 Answers  


How can you join flat file, oracle as a sources?

4 Answers   IBM,


what is the diff between sequential file and fileset stages?

3 Answers  


i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer

2 Answers  


Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 Answers   Cap Gemini, IBM,






how can you generate sequence number using only the sequential file stage?

3 Answers   TIAA CREF,


Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.

1 Answers   IBM,


Can you explain link buffering?

0 Answers  


I have a few records just I want to store data in to targets cycling way how?

0 Answers   Polaris,


whats relation between configuration file and datasets?

2 Answers   L&T, Wipro,


how to handle null values using transformer stage?

1 Answers  


1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...

2 Answers   iGate,


Categories