using Pivot stage seq--->pivot--->dataset in pivot output col name

SOURCE
CITY NAME1 NAME2 NAME3 NAME4
BGLR HCL CSC IBM TCS

TARGET
CITY COMPANY
BGLR HCL
BGLR CSC
BGLR IBM
BGLR TCS

Question Posted / chethankumar km

1 Answers
5551 Views
I also Faced
E-Mail Answers

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 are the components of ascential data stage?

1190

Explain ibm infosphere information server and highlight its main features?

1091

How many types of stage?

1181

how to sort two columns in single job in datastage.

2905

What is datastage?

1088

How and where you used hash file?

1176

what are the devoleper roles in real time? plz tell i am new to datastage....

2164

What is ibm datastage flow designer?

1151

On which interface you will be working as a developer?

1049

Which commands are used to import and export the datastage jobs?

1414

What are the main differences you have observed between 7.x and 8.x version of datastage?

1089

What is staging variable?

1099

Why fact table is in normal form?

1256

Terminate Activity

1284

How a source file is populated?

1068