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?
Answer Posted / sonali s
The above solution doesnt give required output. The requirement is as below:
Input:
A
B
B
C
D
D
D
Output should have 2 files as below.
File 1
A
C
File 2
B
B
D
D
D
Please provide solution for this
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How we can covert server job to a parallel job?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Can you explain tagbatch restructure operator?
describe the Steps to confiure a Qlogic switch
What is the difference between odbc and drs stage?
sed,awk,head
Where the datastage stored his repository?
what is ds administrator used for?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What is quality stage?
Define ds designer?
Differentiate between hash file and sequential file?
Differentiate between odbc and drs stage?
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)
Can you implement SCD2 using join, transformer and funnel stage?