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
If informatica has its scheduler why using third party scheduler?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the guidelines to be followed while using union transformation?
Tell me about MD5 functions in informatica
What are the features of complex mapping?
Enlist the tasks for which source qualifier transformation is used.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Clarify the utilization of aggregator cache record?
How to load the data from people soft hrm to people soft erm using informatica?
Separate from a database, an information bazaar, and an information stockroom?
What's the layout of parameter file (what does a parameter file contain?)?
What are data-driven sessions?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is fact table? Explain the different kinds of facts.