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 many number of sessions can one group in batches?
In warehouses how many schemas are there?
How can repository reports be accessed without sql or other transformations?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Explain sessions. Explain how batches are used to combine executions?
What is a sequence generator transformation?
What are the designer tools for creating transformations?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is the meaning of decode in informatica?
Define sessions in informatica etl?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What are the types of schemas we have in data warehouse.
Why do you use Mapping Parameter and mapping variable?
What is workflow monitor?