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
what is song in infrmatica...?
Explain lookup transformation is active in informatica
What is workflow monitor?
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?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Explain pushdown optimization $pushdownconfig parameter - informatica
Explain incremental aggregation in informatica
What do think which one is the better joiner or look up?
How would you join a node to the already existing domain?
How do you migrate data from one environment to another?
How many ways a relational source definition can be updated and what are they?
What is the use of transformation?
How can we use batches?
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?