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
Differentiate between a repository server and a powerhouse?
What is data transformation manager process?
Parameter and variable differences
Write the advantages of partitioning a session?
What are the static cache and dynamic cache in informatica?
How to generate or load values in to the target table based on a column value using informatica etl tool.
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
write a query to retrieve the latest records from the table sorted by version(scd)
How to update source definition?
If informatica has its scheduler why using third party scheduler?
How to load the data from people soft hrm to people soft erm using informatica?
wf dont have integration severances how you can run?
explan ur project architecture?
Explain in detail scd type 2 through mapping.
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?