Warehouse DataStage Question: Download Warehouse DataStage PDF
How to eliminate duplicate rows?
Answer:
The Duplicates can be eliminated by loading thecorresponding data in the Hash file. Specify the columns on which u want to eliminate as the keys of hash.
you can delete duplicate records from source itself using datastage taking option as userdefined query, instead of taking table read option. and u can use remove duplicate stage in datastage. and using of hashfile as source also based on the hash key.
you can delete duplicate records from source itself using datastage taking option as userdefined query, instead of taking table read option. and u can use remove duplicate stage in datastage. and using of hashfile as source also based on the hash key.
Previous Question | Next Question |
How good are you with your PL/SQL please explain? | What is differences between Oracle8i/9i? |