i have data like
sam
ram
sam
raj
ram

I want two targets
trgt1
ram
sam

trgt2

raj
how can i do this in datastage?

Answer Posted / reddymkl.dwh

Small correction Ramu, Instead of Transformer stage use Filter stage it will give performance gain.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the custome stage in datastage? how can we impliment that one? plz tell me

1914


What are iconv and oconv?

779


What is ibm datastage?

609


Can you explain tagbatch restructure operator?

705


How do you reject records in a transformer?

632






what is the use of skid in reporting?

1960


Lookup constraints

844


how many rows sorted in sort stage by default in server jobs

3565


What are the different layers in the information server architecture?

645


How complex jobs are implemented in datstage to improve performance?

604


What is the difference between hashfile and sequential file?

728


Differentiate between operational datastage (ods) and data warehouse?

678


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

657


What is difference between symmetric multiprocessing and massive parallel processing?

660


What are datastage sequences?

673