DSXchange

Thanks for your reply, that helps ALOT! :D But when you use a sparse lookup you get performance issues if your driving and reference data ratio is more than 1:100 What do you mean by this ratio? Are you saying that if the size of the reference data is large compared to the driving data then there wi...

Hi all, I've got SCD of type 1 working correctly within DataStage so I can now figure out which records I have previously processed. However, I'm now struggling to figure out which records I have previously delivered. I don't know if that really makes sense, but here is the currently solution: 1. I ...