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 are the steps needed to create a simple basic datastage job?

0 Answers  

What are the third party tools you used in your project?

1 Answers   IBM,

what is the difference between the active datawarehouse and datawarehouse

1 Answers   TCS,

hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha

6 Answers   CTS,

Name the different sorting methods in datastage.

0 Answers  

how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

2 Answers   Wipro,

Differentiate between odbc and drs stage?

0 Answers  

I have 100 records how can I load at a time from the single time

1 Answers  

How can we do null handling in sequential files

3 Answers   Reliance,

How do u call shellscript/Batch file from DS?

4 Answers   HP,

what is flow of project?

0 Answers   HSBC, IBM,

Can we use Round Robin for aggregator?is there any benefit underlying?

3 Answers   TCS,

For more Data Stage Interview Questions Click Here
Categories