STEP 1) TRANSFORMER STAGE PROPERTIES--> ADVANCED --> EXECUTION MODE

How to remove duplicates in transformer stage? in parallel
mode

Question Posted / praveen sarva

6 Answers
17211 Views
Syntel, TCS, I also Faced
E-Mail Answers

Answer Posted / praveen sarva

STEP 1) TRANSFORMER STAGE PROPERTIES--> ADVANCED -->
EXECUTION MODE ---> PARLLEL

STEP 2) TRANSFORMER STAGE PROPERTIES --> INPUT -->
PARTITIONING--> PARTITION TYPE --> HASH ---> ENABLE SORT ---
> ENABLE UNIQUE

Simple u will get non duplicate records....

Is This Answer Correct ?

11 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can you highlight the main features of ibm infosphere information server?

1057

Have you used Unstructured data?

1275

What is the roundrobin collector?

1052

What are sequencers?

1071

Where do the datastage jobs get stored?

1160

What is datastage?

1042

project Steps,hits, Project level HArd things,Solved methods?

2074

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

1094

What is the difference between informatica and datastage?

1160

Lookup constraints

1207

How can we improve the performance in datastage?

1073

what is the difference between == and eq in UNIX shell scripting?

1449

What are the important features of datastage?

1063

What is a datastage job?

973

How do you reject records in a transformer?

1071