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
What is the difference between the local container and shared container?
Explain entity, attribute and relationship in datastage?
what is use of SDR function?
Define meta stage?
Distinguish between informatica & datastage. Which one would you choose and why?
What is ibm datastage?
What are the components of datastage?
What is aggtorec restructure operator?
What is use Array size in datastage
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
explain about citrix scheduling tool in datastage
What are the stages in datastage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
how to export or import the jobs in .ISX file
Describe the architecture of datastage?