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

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2341


Which commands are used to import and export the datastage jobs?

1191


Differentiate between Join, Merge and Lookup stage?

882


What is datastage?

872


what is the use of skid in reporting?

2160


Lookup constraints

1052


Define orabulk and bcp stages?

922


im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

1886


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2989


Define repository tables in datastage?

934


what is repositery?

1574


What are the enhancements made in datastage 7.5 compare with 7.0?

947


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3461


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2045


Define Data Stage?

876