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
- 24538 Views
- CTS, I also Faced
- E-Mail Answers
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
How do you start developing a datastage project?
What is quality stage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
how to implement scd2 in datastage 7.5 with lookup stage
What are the types of jobs we have in datastage?
What is the difference between Datastage 7.5 and 7.0?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
what is use of SDR function?
Name the different sorting methods in datastage.
What is orabulk stage?
How to implement complex jobs in data stage?
What are the types of containers in datastage?
What is the difference between passive stage and active stage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Name the third party tools that can be used in datastage?
