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
- 24217 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
Difference between sequential file and data set?
Triggers,VIEW,Procedures
What is quality stage?
Explain connectivity between datastage with datasources?
How do y read Sequential file from job control?
Explain the situation where you have applied SCD in your project?
What is a folder? Difference types of stages?
What is the use of datastage director?
What is merge stage?
What are some different alternative commands associated with "dsjob"?
What is orabulk stage?
Differentiate between Join, Merge and Lookup stage?
how to implement scd2 in datastage 7.5 with lookup stage
On which Dimension Table you implemented SCD Type in your Project
What is the difference between datastage and informatica?
