Interested to Buy Any Domain ? << Click Here >> for more details...
Using Expression transformation how to remove duplicate
records from a relational source?
- 4 Answers
- 24635 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
What is resilience time?
What is a snowflake schema?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What are the tuning techniques you applied during your last project
What are the steps involved in the migration from older version to newer version of Informatica Server?
What are the differences between joiner transformation and source qualifier transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is option by which we can run all the sessions in a batch simultaneously?
What is meant by LDAP users?
Can we create two repositories on same database instance in oracle?
Why union transformation is an active transformation?
What are the components of Informatica? And what is the purpose of each?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How might you approve all mappings in the archive all the while?
