how will you remove the duplicate records from flat file
without using sorter?
Answer Posted / sathish
use aggregater T/R after source qualifier select all ports in group by clause it will removes the duplicates
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
How can we improve session performance in aggregator transformation?
What is rank transformation in informatica
What are the new features of informatica 9.x at the developer level?
Explain the shared cache and re-cache?
Explain the tuning lookup transformation - informatica
Global and Local shortcuts. Advantages.
What is lookup change?
How to load a Dimension ? and how to load a fact table?
Describe data concatenation?
How to update a particular record in target with out running whole workflow?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
how to load rows into fact table in data warehouse
Can we create a node as a gateway node and the same node can be assigned to a grid?
What are pre and post-session shell commands?
What is a repository? And how to add it in an informatica client?