Thanks for prompt response!! - Where is your source table stored: SAS or DB2? My source and target stored in same DB2 - Does your source table contain deltas (just changes) or is it a full daily snapshot? Yes, it is contain deltas change. If deltas: Could you have more than one row per primary key (like journal data) in your source table? No, What's the relationship in volumes between source and target (like 1M rows in source and 1000M rows current records in target). 50M - Do you also have to expire ("delete") records without adding a new current record? And if yes: Do you get a separate deletion source for this or do you have to work it out? We do not have My source and target is same DB2.most of the cases i am using Passthrough for DB processing.Could you please guide if there is way and i can redirect SCD type2/Table loader work table in DB only.
... View more