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
- 8461 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
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What are the functionalities of link collector?
How do you reject records in a transformer?
How will you move hashed file from one location to another location?
Demonstrate experience in maintaining quality process standards?
options available in sequence job to run,validate?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How to RD using transformer?
Describe the main features of datastage?
What is datastage engine?
What are the main features of datastage?
Define orabulk and bcp stages?
What is the difference between server job and parallel jobs?
Explain Quality stage?
