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
Can you implement SCD2 using join, transformer and funnel stage?
What is a datastage job?
What is the command line function to import and export the ds jobs?
How many Key we can define in remove duplicate stage?
What is a quality stage in datastage tool?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What is the purpose of interprocessor stage in server jobs?
How many types of sorting methods are available in datastage?
On which interface you will be working as a developer?
what is the custome stage in datastage? how can we impliment that one? plz tell me
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
State the difference between an operational datastage and a data warehouse?
Explain how a source file is populated?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks