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?
Answer Posted / purba
Input:
A
B
B
C
D
D
D
Required output:
A
B
C
D
Solution:
Seq file----->sort stage(create key change column for the I/p key row)
O/p:
A 1
B 1
B 0
C 1
D 1
D 0
D 0
Now take filter stage to filter for key column=0 & keycol=1
We get 2 outputs:
A. B
B. D
C. D
D
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different plug-ins stages used in your projects?
In Datastage, how you can fix the truncated data error?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Can you explain tagbatch restructure operator?
Describe routines in datastage? Enlist various types of routines.
Nls stands for what in datastage?
Why do you need stage variables?
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)
Distinguish between informatica & datastage. Which one would you choose and why?
what is 'reconsideration error' and how can i respond to this error and how to debug this
How do you generate sequence number in datastage?
What are the some differences between 7.x and 8.x version of datastage?
how to sort two columns in single job in datastage.
Have you used Unstructured data?
What are the enhancements made in datastage 7.5 compare with 7.0?