in BODS - SCD Type2 - Flag is not updating properly

[Former Member]

Hi All,

I updated the same record 4 times and run the job 4 times. in BODS -  SCD - Type2 table. 

105   Mamatha  Mg Rd. Hyd    Bagladesh

105   Mamatha  Mg Rd. Hyd    Pakistan

105   Mamatha  Mg Rd. NY     USA

105   Mamatha  Mg Rd. UK     UK

but the FLAG is not updating properly.  Please find the screen shot.

please let me know the reason.

[former_member208402]

Hi Sashi,

Can you please post screenshot of your history preservation and also table comparison transform (inside).

[Former Member]

please find the screen shot

regards,

sashi

[Former Member]

[former_member208402]

Hi Sashi,

Please drag column SKey in input primary key clomuns in Table comparison and now run the job. Both CustID and SKey columns should be in input primary key columns.

Also delete the data from Target table and start a fresh load.

Please let me know if it worked or not.

Thanks,

Ravi kiran.