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
- 8615 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Define Job control?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
How many types of stage?
sed,awk,head
Define orabulk and bcp stages?
How do you generate sequence number in datastage?
What is difference between join, merge and lookup stage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Difference between in process and inter process?
What are the types of containers?
What is difference between symmetric multiprocessing and massive parallel processing?
How to reverse the string using SQL?
How to manage date conversion in Datastage?
Why we use surrogate key?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
