How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
- 7 Answers
- 20496 Views
- iNautix, I also Faced
- E-Mail Answers
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
What is the sql query overwrite in source qualifier in informatica
In warehouses how many schemas are there?
Explain scd type 3 through mapping.
What do you mean incremental aggregation?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the tasks that can be performed using sq?
how tokens will generate?
What are the transformations that are not supported in mapplet?
What do you mean by filter transformation?
How to extract sap data using informatica? What is abap? What are idocs?
Different sorts of metadata that stores in the storage facility?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
can we override a native sql query within informatica? Where do we do it?
can anyone suggest best free Talend data integration training online
Explain dynamic target flat file name generation in informatica
