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
is this approcah right?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.