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 informatica worklet?

794


explan ur project architecture?

1832


What is the fact table?

793


What is meant by lookup transformation? Explain the types of lookup transformation?

746


Informatica settings are available in which file?

779


Sequence generator, when you move from develoment to production how will you reset

1672


Explain pushdown optimization and types in informatica

854


What are the static cache and dynamic cache in informatica?

970


How to call shell scripts from informatica?

767


Which transformation should we use to normalise the COBOL and relational sources?

965


Which development components of informatica have the highest usage?

816


Which files are created during the session rums by informatics server?

929


How many number of sessions can one group in batches?

905


permutations of mapplet

2259


Different qualification between a related rotate toward the sky and isolates look upward?

775