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????
Answers were Sorted based on User's Feedback
Answer / chandu
S.D sahu answer is correct but don't use transformer stage.
use sort stage and use option as createKeyChangeColumn =
True it allows one virtual key column as keychange column
i.e unique records display as 1 and duplicate records it
give 0 and use simple filter stage and that use option or
give where clause =keychangecolumn=1 . unique records are
went to one dataset and use filter stage stage another
option is output rejects =true duplicate records went to
another dataset.
This is the best answer
Is This Answer Correct ? | 21 Yes | 1 No |
Answer / prasad
by using create key change column is true is disp;ays
duplicates records
if it is false it displays non duplicate records
first keep all the records in sort order
Is This Answer Correct ? | 4 Yes | 6 No |
What is the Difference Between DataStage 7.5 version and 8.1 Version?
in aggregator , how can i get the sum in readable format
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
what is the main difference between sorragate key n primary key in one word
What is the use of hoursfromtime() function in transformer stage in datastage?
1)Source file contains one record, I want 100 records in target file.
Name the different sorting methods in datastage.
How can one find bugs in job sequence?
Difference between server jobs & parallel jobs?
I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?
how many datamarts we will use in real time project and when will use the datamart?pls send the replay early
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?