Different Delta Options other than CDC

In a specific data flow, which has a source table, a transform, and a target table: How would you update the target table with any changes in source table without using a CDC?

chintam820
Profile Answers by chintam820 Questions by chintam820
Dec 6th, 2011
6
4397

Questions by chintam820

Data Integration

Answer

Showing Answers 1 - 6 of 6 Answers

deepa

Jun 6th, 2013

We have transforms called table comparison and map operation. by using table table comparison transform we can find the changes from source.

manoj2256
Profile Answers by manoj2256

Jan 23rd, 2015

While loading use table comparison, cache method and check input contains duplicate record. BODS will then consider the new record in cache table to be inserted and any duplicate will be then treated as an update in target. In this way only one record will be inserted. This method will be optimized in case of low volume data where you can use cache. Hope this help.