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
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / bharath
if inputlnk.col1%3= 1 then outputlnk.col1=inputlnk.col2
else inputlnk.col2
if inputlnk.col1%3= 2 then outputlnk.col2=inputlnk.col2
else inputlnk.col2
if inputlnk.col1%3= 0 then outputlnk.col3=inputlnk.col2
else inputlnk.col2
use above conditions in transformer stage
and then
change the column names using modify stage
as col1 = eno
col2 = ename
col3 = sal
let me know right answer, if i'm wrong...
..
Is This Answer Correct ? | 3 Yes | 5 No |
how to find no.of records in sequntial file itself?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
how to validate the jobs
what is the custome stage in datastage? how can we impliment that one? plz tell me
How we can covert server job to a parallel job?
1.What is a delta record? How you will read it? 2.What are the different types of sorting?
What is the difference between in process and inter process?
How many areas for files does datastage have?
What are the types of views in datastage director?
What is the difference between validate and compile?
What are the functionalities of link partitioner?
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com