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
- 7866 Views
- I also Faced
- E-Mail Answers
Answer Posted / subhash
SRC--->TFM--->PIVOT----> TGT
In TFM, use below logic
col1 MOD 3----->col1
then out from TFM is:
col1,col2
1,1
2,rajesh
0,15000
1,2
2,suresh
0,16000
1,3
2,veeru
0,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 ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is the differentiate between data file and descriptor file?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Does datastage support slowly changing dimensions ?
Explain entity, attribute and relationship in datastage?
What are the repository tables in datastage?
how to add a new records into source?
What is the difference between account and directory options ?
What is difference between server jobs & parallel jobs?
What are the differences between datastage and informatica?
What are data elements?
how to abort the job its matain duplicates?
What is a quality stage in datastage tool?
describe the Steps to confiure a Qlogic switch
What is the difference between passive stage and active stage?
How to manage date conversion in Datastage?
