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
- 7985 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
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
What are the types of containers in datastage?
How we can covert server job to a parallel job?
What are the important features of datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is the different type of jobs in datastage?
What is quality stage?
Notification Activity
What is the roundrobin collector?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
How will you move hashed file from one location to another location?
How and where you used hash file?
Differentiate between operational datastage (ods) and data warehouse?
How do you run datastage job from the command line?
What is the difference between datastage and informatica?
