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
- 23130 Views
- CTS, I also Faced
- E-Mail Answers
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
Where do you see different stages in the designer?
Name the different sorting methods in datastage.
What can we do with datastage director?
How do you schedule or monitoring the job?
What is active and passive stage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Distinguish between informatica & datastage. Which one would you choose and why?
What is the purpose of pivot stage?
Why do we use link partitioner and link collector in datastage?
Explain ibm infosphere information server and highlight its main features?
What is the importance of the exception activity in datastage?
In Datastage, how you can fix the truncated data error?
Difference between sequential file and data set?
How and where you used hash file?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
