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
- 7752 Views
- I also Faced
- E-Mail Answers
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 |
1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...
What is the importance of the exception activity in datastage?
Nls stands for what in datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
On which interface you will be working as a developer?
Teradata 
