Using Expression transformation how to remove duplicate
records from a relational source?

Answer Posted / bijay

The mapping should be like this
SRC->SQ->EXP->TARGET
In source qualifier transformation select 'ENABLE DISTINCT',
then it will send only distinct record to the expression transformtion. And From expression transformation simply connect to the target

Is This Answer Correct ?    2 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is song in infrmatica...?

1943


Explain lookup transformation is active in informatica

887


What is workflow monitor?

819


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

9436


Name at least 5 different types of transformations used in mapping design and state the use of each.?

919


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2090


Explain pushdown optimization $pushdownconfig parameter - informatica

941


Explain incremental aggregation in informatica

889


What do think which one is the better joiner or look up?

998


How would you join a node to the already existing domain?

924


How do you migrate data from one environment to another?

874


How many ways a relational source definition can be updated and what are they?

815


What is the use of transformation?

783


How can we use batches?

802


How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1767