In the source seq file have 2 columns, i.e
input:
col1,col2
1,1
2,rajesh
3,15000
4,2
5,suresh
6,16000
7,3
8,veeru
9,17000
I want in the output like:
eno,ename,sal
1,rajesh,15000
2,suresh,16000
3,veeru,17000
any one answer this scenario
- 3 Answers
- 6603 Views
- I also Faced
- E-Mail Answers
Answer Posted / subhash
SRC--->TFM--->PIVOT----> TGT
In TFM, use below logic
if col1<4 then 1 elseIf col1>3 AND col1<7 then 2 else 3-----
>col1
then out from TFM is:
col1,col2
1,1
1,rajesh
1,15000
2,2
2,suresh
2,16000
3,3
3,veeru
3,17000
In PIVOT, do vertical PIVOT, group by column is 'col1' and
pivot column is 'col2' then we will get desired output.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is data partitioning?
Differentiate between hash file and sequential file?
What all are the different way to run a job?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
How to find value from a column in a dataset?
How you can fix the truncated data error in datastage?
what is the use of surogate key in datastage
How many types of stage?
How to reverse the string using unix?
how can we create rank using datastage?what is the meaning of rank?
Define Merge?
Explain Quality stage?
What are the different types of lookups in datastage?
What is staging variable?
What steps should be taken to improve Datastage jobs?
