SOURCE
CITY NAME1 NAME2 NAME3 NAME4
BGLR HCL CSC IBM TCS

TARGET
CITY COMPANY
BGLR HCL
BGLR CSC
BGLR IBM
BGLR TCS

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between the local container and shared container?

643


Explain entity, attribute and relationship in datastage?

629


what is use of SDR function?

4706


Define meta stage?

776


Distinguish between informatica & datastage. Which one would you choose and why?

578






What is ibm datastage?

601


What are the components of datastage?

646


What is aggtorec restructure operator?

722


What is use Array size in datastage

1300


file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

534


explain about citrix scheduling tool in datastage

1808


What are the stages in datastage?

635


Difference between ‘validated ok’ and ‘compiled’ in data stage?

663


how to export or import the jobs in .ISX file

710


Describe the architecture of datastage?

566