Interested to Buy Any Domain ? << Click Here >> for more details...
eno ename esal acct1 acct2 amount1 amount2
100 suresh 10000 sbi1 sbi2 1000 2000
this is our sourse data
i would loke to disply like this
eno ename esal acct amount
100 suresh 10000 sbi1 1000
100 suresh 10000 sbi2 2000
- 2 Answers
- 8614 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / geetha
Using @iteration=2 looping and define two stage variables and put the if else condition to provide the derivation (ex: @iteration=1 then acct1 else if @iteration=2 then acct2.)
| Is This Answer Correct ? | 0 Yes | 0 No |
How do you generate sequence number in datastage?
I have 100 records how can I load at a time from the single time
2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?
What is the difference between orabulk and bcp stages?
what is mapping lookup
how to write server Routine coding?
Define meta stage?
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me
iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..
How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?
How can we do null handling in sequential files?
If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically
Teradata 
