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

How many types of hash files are there?

0 Answers  


it is possible to load two tables data into one sequential file?if possible how?plz share with me?

6 Answers   TCS,


wt is the difference between swith and filter stage

6 Answers   IBM,


I have a few records just I want to store each records tow times in target how?

2 Answers   Polaris,


WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD

8 Answers   L&T,


What are the types of containers and how to create them?

0 Answers  


Define Data Stage?

0 Answers  


iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..

4 Answers   Wipro,


What is Cleanup Resources and when do you use it?

2 Answers  


how does work server jobs?

1 Answers  


How to delete the data in dataset?types of deleting the data in dataset?

4 Answers   HSBC,


How do you generate sequence number in datastage?

0 Answers  


Categories