SOURCE
CITY NAME1 NAME2 NAME3 NAME4
BGLR HCL CSC IBM TCS

TARGET
CITY COMPANY
BGLR HCL
BGLR CSC
BGLR IBM
BGLR TCS



SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL ..

Answer / chethankumar km

using Pivot stage
seq--->pivot--->dataset
in pivot output col name one same as city second one as
company in that col in derivation name1,name2,name3,name4.
compile and run will get desired output.

Is This Answer Correct ?    12 Yes 0 No

Post New Answer

More Data Stage Interview Questions

What is the process of killing a job in datastage?

0 Answers  


On which Dimension Table you implemented SCD Type in your Project

0 Answers  


2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?

1 Answers  


i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring

13 Answers   Bank Of America, IBM,


what is the use of surogate key in datastage

0 Answers   TCS,






how many write modes are there in ds

2 Answers   IBM,


What is a merge in datastage?

0 Answers  


How to reverse the string using unix?

0 Answers   CTS,


Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 Answers  


What is PX?

2 Answers   IBM,


Describe the main features of datastage?

0 Answers  


Could anyone give brief explanation bout datastage admin

0 Answers  


Categories