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
Explain the informatica workflow?
What is resilience time?
what is INFORMATICA TESTING process
What is powercenter on grid?
How many number of sessions can one group in batches?
what is SDLC way of code development?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Explain pushdown optimization and types in informatica
What are the different components of powercenter?
How to update or delete the rows in a target, which do not have key fields?
What is a predefined event?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is informatica worklet?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?