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????
- 3 Answers
- 7810 Views
- I also Faced
- E-Mail Answers
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
Can you highlight the main features of ibm infosphere information server?
how to write server Routine coding?
Define project in datastage?
what is ds administrator used for?
What is staging variable?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is datastage engine?
How do you reject records in a transformer?
EXPLAIN SCD
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Which commands are used to import and export the datastage jobs?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
How to Remove Duplicate using SQL?
What is merge stage?
