DSXchange

hi,
Trying to build fact table, I am thinking of this approach please let me if anything can be improved

Stg_table----transformer----changecapture---filter --(update and insert on fct table)


2) all look ups for dimensions on transformer

(Master Table will be stage_table and all keys will come from dimension table)

Thanks

To apply CDC u need 2 Lookup to check for Non-key field value changes.
Include a Lookup between Stg_table & Transformer.

Welcome aboard.

Unfortunately you are wrong in your assertion. The change detection stages can take one input directly from the target table. No Lookup stage is required.

I suspect you first learned change detection in a server job environment.