How to eliminate duplicate rows?
Submitted by: AdministratorThe 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Warehouse DataStage Job Interview Questions And Answers
Top Warehouse DataStage Questions
| ☺ | How to fix the error "OCI has fetched truncated data" in DataStage? |
| ☺ | How to kill the job in data stage? |
| ☺ | Explain What does a Config File in parallel extender consist of? |
| ☺ | Explain How to handle the rejected rows in datastage? |
| ☺ | What is iconv and oconv functions? |
Top Data Warehouse Job Categories
| ☺ | Warehouse Assistant Interview Questions. |
| ☺ | Ab Initio Interview Questions. |
| ☺ | Data Stage Interview Questions. |
| ☺ | ColdFusion Interview Questions. |
| ☺ | Data Warehouse Supervisor Interview Questions. |
