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
- 24274 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
What is a datastage job?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What are the benefits of datastage?
What are the components of ascential data stage?
Explain ibm infosphere information server and highlight its main features?
What are data elements?
Is the value of staging variable stored temporarily or permanently?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
How and where you used hash file?
How many types of hash files are there?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
how do u catch bad rows from OCI stage? And what CLI stands for?
How to read the length of word in unix?
What is ibm datastage flow designer?
Name the different sorting methods in datastage.
