Thursday 7 January 2016

In what case do you use dynamic cache and static cache in connected and unconnected transformations?

Dynamic cache is used when you have to update master table and slowly changing dimensions (SCD) type 1
 For flat files Static cache is used.

No comments:

Post a Comment