Create a job to load all unique products in one table and the duplicate rows in

Create a job to load all unique products in one table and the duplicate rows in to another table.

The first table should contain the following output

A
D

The second target should contain the following output

B
B
B
C
C

Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table.

The first table should contain the following output

A
B
C
D

The second table should contain the following output

B
B
C

Question Posted / suneelmanne

3 Answers
8859 Views
Deloitte, IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Create a job to load all unique products in one table and the duplicate rows in to another table. ..

Answer / sudheer

answer for Q2, use sort stage and use generate change key column option. use filter stage to send all change key columns having value=1 to move in to a file which generates A B C D, and filter records having value=0 to another file which generates B B C.

Is This Answer Correct ?

7 Yes

1 No

Create a job to load all unique products in one table and the duplicate rows in to another table. ..

Answer / unknown

Q1: First use Aggregate stage- Row Count property then filter stage to separate Row Count 1 and more than 1.

Is This Answer Correct ?

4 Yes

0 No

Create a job to load all unique products in one table and the duplicate rows in to another table. ..

Answer / nams

It can be done by unix uniq -u file_Name and uniq -d file_Name
or it can be done from datastage sequential file stage filter option from property.....write command overthere like above.....

Is This Answer Correct ?

1 Yes

3 No

Post New Answer