A Staging area in a DW is used as a temporary space to hold all therecords from the source system. So more or less it should be exact replica of the sourcesystems except for the laod startegy where we use truncate and reload options.
So create using the same layout as in your source tables or using the Generate SQL option in theWarehouse Designer tab.
No comments:
Post a Comment