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
- 7862 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
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Can you filter data in hashed file?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Highlight the main features of datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Name the different types of Lookups in Datastage?
Triggers,VIEW,Procedures
Can you highlight the main features of ibm infosphere information server?
Distinguish between informatica & datastage. Which one would you choose and why?
What is use Array size in datastage
Describe the main features of datastage?
Define data aggregation?
Can you explain link buffering?
Terminate Activity
what is 'reconsideration error' and how can i respond to this error and how to debug this
