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


Please Help Members By Posting Answers For Below Questions

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2547


What is the difference between informatica and datastage?

660


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

4572


Differentiate between datastage and datastage tx?

601


What all the types of jobs you developed?

668






What is active and passive stage?

884


Why do we use exception activity in Datastage?

732


Have you have ever worked in unix environment and why it is useful in datastage?

657


How do y read Sequential file from job control?

14421


how to delete one row in target dataset

2590


Explain ibm infosphere information server and highlight its main features?

615


How to reverse the string using unix?

2815


How a server job can be converted to a parallel job?

625


Can we use target hash file as a lookup ?

2818


What is usage analysis in datastage?

820