SOURCE
CITY NAME1 NAME2 NAME3 NAME4
BGLR HCL CSC IBM TCS
TARGET
CITY COMPANY
BGLR HCL
BGLR CSC
BGLR IBM
BGLR TCS
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 |
Give an idea of system variables.
What are the types of containers?
1)How to Duplicate Records Delete in Sequential file?
how do u reduce warnings
Name the different sorting methods in datastage.
which unix commands mostly used in datastage
How can u write exception handling in seq file????
What is exact difference between Parallel Jobs and server Jobs..
How do you start developing a datastage project?
How do u call shellscript/Batch file from DS?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
How to enter a log in auditing table whenever a job get finished?