Please write some Real Time Data Services Scenarios

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

What would you do when all the duplicate values are being updated in target table and the job is adding records continuously without any pause ?

Prasanna

• May 5th, 2014

Use Table comparison Transform ,find out the difference and load into the target table.

selva

• Oct 8th, 2013

Target table select Yes to use auto correct loading. Auto correct loading ensures that the same row is not duplicated in a target table

Answer Question  Select Best Answer