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


SOURCE
CITY NAME1 NAME2 NAME3 NAME4
BGLR HCL CSC IBM TCS

TARGET
CITY COMPANY
BGLR HCL
BGLR CSC
BGLR IBM
BGLR TCS



SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL ..

Answer / chethankumar km

using Pivot stage
seq--->pivot--->dataset
in pivot output col name one same as city second one as
company in that col in derivation name1,name2,name3,name4.
compile and run will get desired output.

Is This Answer Correct ?    12 Yes 0 No

Post New Answer

More Data Stage Interview Questions

Give an idea of system variables.

0 Answers  


What are the types of containers?

0 Answers  


1)How to Duplicate Records Delete in Sequential file?

4 Answers   IBM, TCS,


how do u reduce warnings

1 Answers   CGI,


Name the different sorting methods in datastage.

0 Answers  


which unix commands mostly used in datastage

3 Answers   HSBC,


How can u write exception handling in seq file????

2 Answers   IBM,


What is exact difference between Parallel Jobs and server Jobs..

8 Answers   DELL, IBM,


How do you start developing a datastage project?

0 Answers  


How do u call shellscript/Batch file from DS?

4 Answers   HP,


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

0 Answers  


How to enter a log in auditing table whenever a job get finished?

2 Answers   L&T,


Categories