how will you remove the duplicate records from flat file
without using sorter?
Answer Posted / krishnakanthch
We can use the option 'SELECT DISTINCT' in the source
qualifier.
Anybody please tell me whether this works or not.
| Is This Answer Correct ? | 5 Yes | 23 No |
Post New Answer View All Answers
How do you load unique records into one target table and duplicate records into a different target table?
lookup transformation with screenshots
What is a pre-defined event and user-defined event?
Informatica settings are available in which file?
Partition, what happens if the specified key range is shorter and longer
pmscmd startworkflow -sv
What is rank transformation?
How many numbers of sessions can one group in batches?
What is the difference between source qualifier transformations source filter to filter transformation?
have u done any performance tuning? how u ll do?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is data caches/ index caches?
How to improve the performance of a session using sorter transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How to create or import flat file definition in to the warehouse designer?