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
- 8620 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 |
i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring
13 Answers Bank Of America, IBM,
how to call routines in stages?
where we use column generator stage in real time scenario?
What is datastage?
How do you start developing a datastage project?
LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Is the value of staging variable stored temporarily or permanently?
what r the stages mostly used in realtime scenarios
what is the use of surogate key in datastage
there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities
Teradata 
