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 are the performance considerations when working with aggregator transformation?
What is informatica?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Can anyone tell me the new features in Informatica 9 Version?
If informatica has its scheduler why using third party scheduler?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Briefly describe lookup transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What are the tasks that source qualifier perform?
Define mapplet?
What are the different types of repositories created using informatica?
Explain sessions?
In how many ways we can create ports?
What is a difference between complete, stop and abort?