Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8983 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
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)
How many types of sorting methods are available in datastage?
Why do you need stage variables?
Explain the importance of surrogate key in data warehousing?
How many types of views are there in a datastage director?
Can you implement SCD2 using join, transformer and funnel stage?
Define meta stage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Define repository tables in datastage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Difference between in process and inter process?
What are the different kinds of views available in a datastage director?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
CHANGE CAPTURE
What are the various kinds of containers available in datastage?
