Interested to Buy Any Domain ? << Click Here >> for more details...
How do you remove duplicate records in informatica?
- 1 Answers
- 1452 Views
- I also Faced
- E-Mail Answers
Answer Posted / lahari
There are multiple ways to do it.
1.if source is RDBMS then we can filter by selecting distinct option.
2.In sorter transformation select distinct.
3.In Aggregator transformation select all ports as group by key.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
explain one complex mapping with logic? sales project?
What is an active transformation?
What is data transformation manager process?
How do you update the records with or without using update strategy?
What is a rank transform?
server hot-ws270 is connect to Repository B. What does it mean?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is a node in Informatica?
How many transformations can be used in mapplets.
update strategy transformation in informatica
How to generate sequence numbers without using the sequence generator transformation?
What is sorter transformation?
Informatica Checkpoints
difference between repository database and repository service?
Briefly describe lookup transformation?
