Regarding Design

[vijaykumar]

Hi,
My source data has

pogtype pogstatus customercode effective date

Another table has columns

pogtype customer code.

I need to compare the pogstatus.if the pogstatus is the same, I neednot do anything, only if the pogstatus is different I need to update the effectivedate and insert.

cheers;
Vijay

[nick.bond]

I need to compare the pogstatus.if the pogstatus is the same

compare which pogstatus to which pogstatus? Your second table doesn't have pogstatus. Do you mean the pogstatus for the same pogtype and customer from the last file/last run?

Explain a bit more.