Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7823 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
How do u convert the columns to rows in datastage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are the different common services in datastage?
What could be a data source system?
Explain datastage architecture?
Notification Activity
What is process model?
How to Remove Duplicate using SQL?
How do you remove duplicate values in datastage?
What are the functionalities of link partitioner?
in oracle target stage when we use load option and when we use upsert option?
What are transforms and what is the differenece between routines and transforms?
I have a few records just I want to store data in to targets cycling way how?
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 completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
