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?

manoj2256

 Profile Answers by manoj2256 Questions 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...

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.

Answer Question  Select Best Answer