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 informatica worklet?
explan ur project architecture?
What is the fact table?
What is meant by lookup transformation? Explain the types of lookup transformation?
Informatica settings are available in which file?
Sequence generator, when you move from develoment to production how will you reset
Explain pushdown optimization and types in informatica
What are the static cache and dynamic cache in informatica?
How to call shell scripts from informatica?
Which transformation should we use to normalise the COBOL and relational sources?
Which development components of informatica have the highest usage?
Which files are created during the session rums by informatics server?
How many number of sessions can one group in batches?
permutations of mapplet
Different qualification between a related rotate toward the sky and isolates look upward?