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 / ramu

src.....>agg........>t/r..........2trgs
take src as seqfiles and take aggregater stage is for
calculate count of records based on name coloumn,next take
the transformer is for apply constraints like cnt=1 then go
for trg1

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Triggers,VIEW,Procedures

805


What is "fatal error/rdbms code 3996" error?

665


What is the difference between operational data stage (ods) and data warehouse?

679


What are datastage sequences?

673


Can you explain how could anyone drop the index before loading the data in target in datastage?

901






What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

1905


What are routines in datastage? Enlist various types of routines.

631


what is the use of surogate key in datastage

1825


im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

1635


describe the Steps to confiure a Qlogic switch

1944


How to reverse the string using SQL?

898


Which algorithm you used for your hashfile?

695


what is flow of project?

1561


what is the use of skid in reporting?

1960


What is the difference between Datastage 7.5 and 7.0?

677