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
how to write server Routine coding?
What are the differences between datastage and informatica?
How do you start developing a datastage project?
What is the use of datastage director?
Name the different types of Lookups in Datastage?
explain about citrix scheduling tool in datastage
What is datastage engine?
What are some different alternative commands associated with "dsjob"?
What is the use of datastage designer?
Where do the datastage jobs get stored?
Why fact table is in normal form?
how to export or import the jobs in .ISX file
What is the command line function to import and export the ds jobs?
what is use of SDR function?
If you want to use the same piece of code in different jobs, how will you achieve it?