Interested to Buy Any Domain ? << Click Here >> for more details...
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
- 7 Answers
- 21944 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
How do you take back up of repository?
What is an unconnected transformation?
Explain sql transformation in script mode examples in informatica
what is degenerated dimension?
What are pre and post-session shell commands?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Briefly define a session task?
How to load a Dimension ? and how to load a fact table?
How to create Target definition for flat files?
Explain informatica architecture - version 8 / 9
Mention a few design and development best practices for informatica?
What is the need of an ETL tool?
Define enterprise data warehousing?
what is index?how it can work in informatica
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?
