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
Triggers,VIEW,Procedures
What is "fatal error/rdbms code 3996" error?
What is the difference between operational data stage (ods) and data warehouse?
What are datastage sequences?
Can you explain how could anyone drop the index before loading the data in target in datastage?
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)
What are routines in datastage? Enlist various types of routines.
what is the use of surogate key in datastage
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
describe the Steps to confiure a Qlogic switch
How to reverse the string using SQL?
Which algorithm you used for your hashfile?
what is flow of project?
what is the use of skid in reporting?
What is the difference between Datastage 7.5 and 7.0?