DSXchange

lot of convesations went .. good. All given perfect information on how to tackle hashfiles. i think you have not selected correct key fields in HashFile. Key fields whatever there in Source should have to match in Hashfile also. Here i'm listing some points below while comparing or poplating the dat...

how do we capture duplicate records while extracting the data from any database? Here i am using SQL Server database Table for extraction. Is there any function or routine kind of thing in datastage to capture duplicate records? Here i don't need the user defined query to capture duplicates,Because ...