Issue with Table comparsion transformation

26 Views

Hi,

We are having an issue with Table comparsion Transformation in SAP BODS.

Below are the details.

1. We are using three data flows which are executed in sequence.

2. First data flow inserts some dummy records in a dimension dim_X (Truncates and loads the dim_X)

3. Second data flow inserts 100 records in the same dimension dim_X (Appends to existing Dim_X)

3. Third data flow uses a query transform and Table comparsion to check if similar records exists in the compared table then update the record or else insert.

We are using DIM_X as comparsion table in table transform, issue is that even though there exists common records between query transform and compared table (dim_X) in 3rd data flow it is insert a new record rathering than updating.

Please help me out.

Thanks in advance.