How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
Answer Posted / joe
Option 1: using Unix for flat files
Option2: Using Checksum function in the expression to
generate a unique hexadecimal code for each record.
and comparing the same with the next record.
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
How to generate sequence numbers without using the sequence generator transformation?
What are the uses of etl tools?
EXL informatica Questions
How to update or delete the rows in a target, which do not have key fields?
What is meant by incremental aggregation?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What are the different options available for update strategy?
What is a joiner transformation?
Under what condition selecting sorted input in aggregator may fail the session?
If informatica has its scheduler why using third party scheduler?
Explain what transformation and how many are there in informatica?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is event and what are the tasks related to it?
How to do unit testing in informatica? How to load data in informatica ?
How to convert multiple rows to single row (multiple columns) in informatica