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
- 23089 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 are the different kinds of views available in a datastage director?
Describe the main features of datastage?
how to export or import the jobs in .ISX file
How to implement complex jobs in data stage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What all are the different way to run a job?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Define data aggregation?
What are the steps required to kill the job in Datastage?
What is active and passive stage?
Can you explain engine tier in information server?
What is the command line function to import and export the ds jobs?
Lookup constraints
What are the stages in datastage?
Difference between sequential file and data set?
