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

How we can convert rows to columns in datastage?

Answer Posted / manohar palla

I am going to use tranformer and funnel stages to implement the
pivot functionality.


name ph1 ph2---> tranformer--->tf1 name ph1
| funnel---->o/p
|____>tf2 name ph2

tf1 and tf2 are the TWO links from transfomer..

in tf1 we have the name and ph1 where in tf2 name and ph2.

In funnel stage i am going to club the two links and send it
to o/p.


Thanks :)

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can one find bugs in job sequence?

1383


Could anyone give brief explanation bout datastage admin

2350


How to find value from a column in a dataset?

2192


Which algorithm you used for your hashfile?

1174


How one source columns or rows to be loaded in to two different tables?

1124


Name the command line functions to import and export the DS jobs?

1144


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

971


Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1407


I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1002


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1207


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2369


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

3163


Define Job control?

1138


How the ipc stage work?

1123


Have you have ever worked in unix environment and why it is useful in datastage?

1126