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
- 24610 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 steps needed to create a simple basic datastage job?
Explain Quality stage?
What are the components of ascential data stage?
How the ipc stage work?
How you Implemented SCD Type 1 & Type 2 in your project?
Can you implement SCD2 using join, transformer and funnel stage?
What are the important features of datastage?
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)
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What are the primary usages of datastage tool?
What is a merge?
What is the precedence of stage variables,derivations, and constraints?
What are stage variables and constants?
Define Job control?
To see hidden files in LINIX?
