Interested to Buy Any Domain ? << Click Here >> for more details...
Using Expression transformation how to remove duplicate
records from a relational source?
- 4 Answers
- 25004 Views
- I also Faced
- E-Mail Answers
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
How to generate or load values in to the target table based on a column value using informatica etl tool.
draw informatica architecture 8.6 ?
What are the data movement modes in informatica?
what is SDLC way of code development?
difference between informatica 8.1.1 and 8.6
What is the cumulative sum and moving sum?
what is song in infrmatica...?
4 yrs etl devloper roles and responsibilities?any body give solutions
can we override a native sql query within informatica? Where do we do it? How do we do it?
As union transformation gives UNION ALL output, how you will get the UNION output?
What are session parameters ? How do you set them?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is exclusive and normal mode for repository services?
What is a rank transform?
What is a joiner transformation and why it is an active one?
