How to remove duplicates in transformer stage? in parallel
mode

Answer Posted / satya

run u r job in sequencial mode and sort the source data
then play with stage variable's in Transformer.

because in parallel mode data is partioned .

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between hash file and sequential file?

578


Define repository tables in datastage?

699


Describe stream connector?

832


How will you move hashed file from one location to another location?

1655


What are the different types of lookups in datastage?

626






What are the different type of jobs in datastage?

604


How many areas for files does datastage have?

640


On which interface you will be working as a developer?

633


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

1801


Terminate Activity

837


What are the main features of datastage?

660


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1463


What could be a data source system?

575


Can you define merge?

666


What is the roundrobin collector?

635