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...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Question Posted / chandrasekhar.dasg

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 is the difference between validate and compile?

1 Answers   CTS,

What is difference between symmetric multiprocessing and massive parallel processing?

0 Answers  

Can you explain engine tier in information server?

0 Answers  

Define data aggregation?

0 Answers  

what is .dsx files

3 Answers   IBM,

I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?

2 Answers  

HOW CAN U DO ERROR HANDLING IN DATA STAGE?

8 Answers   ME,

i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com

2 Answers   Wipro,

What is Cleanup Resources and when do you use it?

2 Answers  

whats difference between ls -ltr and ls -lrt?

5 Answers   L&T,

1.what is materialized data? 2.how to view the materialized data?

0 Answers   HCL, IBM,

Tell me Wt main advantage of Stage varibles? Project level hints?

4 Answers   Hexaware,

For more Data Stage Interview Questions Click Here
Categories