How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
- 7 Answers
- 20026 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 surrogate key?
Explain your project of banking domian.
What does reusable transformation mean?
how we can load rejected record's at run time?(not through bad files)
What do you understand by a term domain?
What is option by which we can run all the sessions in a batch simultaneously?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is confirmed fact in dataware housing?
What are the types of presistent cache in look up tr.
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is workflow manager?
How do you update the records with or without using update strategy?
What is parallel processing in informatica?
