Interested to Buy Any Domain ? << Click Here >> for more details...
I have source file which contains duplicate data,my
requirement is unique data should pass to one file and
duplicate data should pass another file how?
- 7 Answers
- 24855 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / dilip anand k
Its Simple!!
All you have to do is link your source to a Sort Stage.
Sort the data and generate a Key Change column.
Key Change column = ‘1’ represents that the record is
unique while Key Change Column = ‘0’ represents the
duplicates.
Put a Filter stage and filter out the data into two
different outputs based on the generated Key Change Column.
| Is This Answer Correct ? | 21 Yes | 5 No |
Post New Answer View All Answers
How to find value from a column in a dataset?
What is the use of hoursfromtime() function in transformer stage in datastage?
How do u convert the columns to rows in datastage?
Terminate Activity
What is usage analysis in datastage?
how to export or import the jobs in .ISX file
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
project Steps,hits, Project level HArd things,Solved methods?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Does datastage support slowly changing dimensions ?
What is the project in datastage?
What is ibm datastage?
Differentiate between operational datastage (ods) and data warehouse?
What is meta stage?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
