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
Answers were Sorted based on User's Feedback
Answer / venu
Use Pivot stage......
|Is This Answer Correct ?||11 Yes||3 No|
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|
What are the types of jobs we have in datastage?
What is a range lookup?
what is factless fact table?
What's the Main Function of the Staging area in DWH
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is the difference between orabulk and bcp stages?
How do you design PX Routines ?
With out using Funnel Stage, how to populate the data from different sources to single target
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
on how many columns we can perform aggregation in the Aggregator stage?
HOW CAN WE SEE THE DATA IN DATASET?