if a column contains data like
abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc,
roy,pwe,aaa,xxx,xyz,roy,xok....
how to send the unique data to one source and remaining data
to another source????
Answer Posted / s.d sahu
First use aggregator stage use rowcount,then use transformer
rowcount=1 to one source rest to another.
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
What are the differences between datastage and informatica?
Define ds designer?
What are the partitioning techniques available in link partitioner?
what is the use of materialized view?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Describe stream connector?
Have you have ever worked in unix environment and why it is useful in datastage?
How to read the length of word in unix?
what are the errors,warnings in datastage
What is the precedence of stage variables,derivations, and constraints?
What is the difference between odbc and drs stage?
Is it possible to query a hash file?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
How to find value from a column in a dataset?
What is the difference between server job and parallel jobs?