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 do you import and export data into datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What is the process of killing a job in datastage?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Lookup constraints
explain about citrix scheduling tool in datastage
Describe the architecture of datastage?
What is meta stage?
Why do we use link partitioner and link collector in datastage?
How can we improve performance of data stage jobs?
Can you explain link buffering?
Define Data Stage?
How rejected rows are managed in datastage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side