Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 ..

Answer / venu

Use Pivot stage......

Is This Answer Correct ?    11 Yes 3 No

eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 ..

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

Post New Answer

More Data Stage Interview Questions

What are the types of jobs we have in datastage?

0 Answers  


What is a range lookup?

2 Answers   IBM,


what is factless fact table?

3 Answers   IBM,


What's the Main Function of the Staging area in DWH

3 Answers   Oracle,


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

0 Answers   Cap Gemini, TCS,






What is the difference between orabulk and bcp stages?

0 Answers  


How do you design PX Routines ?

1 Answers  


With out using Funnel Stage, how to populate the data from different sources to single target

12 Answers   Wipro,


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

0 Answers  


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

0 Answers   CGI,


on how many columns we can perform aggregation in the Aggregator stage?

3 Answers   Reliance,


HOW CAN WE SEE THE DATA IN DATASET?

12 Answers   IBM, TCS,






Categories