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
- 21705 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
Where is metadata stored?
Can we create two repositories on same database instance in oracle?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What do you mean by worklet?
What is the different lookup cache(s)?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What are different types of transformations available in informatica?
Is it possible to create multiple domains on a single Informatica server?
how to load dimension table and fact table. plz tell me the steps.
How do you use reject loader.
What is the way to execute pl/sql script using informatica mapping?
What are ETL Tools?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is the difference between writing a joiner query in ANSI style and THETA style?
