Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

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

To see hidden files in LINIX?

0 Answers   CTS,


in oracle target stage when we use load option and when we use upsert option?

0 Answers  


how to sort two columns in single job in datastage.

0 Answers   TCS,


what are the devoleper roles in real time? plz tell i am new to datastage....

0 Answers   Mphasis,


What are the processing stages?

0 Answers  


What is Fastly Changing Dimension?

6 Answers   TCS,


Can you explain kafka connector?

0 Answers  


what is the exact difference between dataset and fileset in datastage?

5 Answers   TCS,


How to reverse the string using unix?

0 Answers   CTS,


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

0 Answers  


How a server job can be converted to a parallel job?

0 Answers  


Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance

2 Answers  


Categories