A Staging area in a DW is used as
a temporary space to hold all the records from the source system. So more or
less it should be exact replica of the source systems except for the load strategy
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 the Warehouse Designer tab.
Thanks
Ur's Hari
If you like this post, please share it by clicking on g+1 Button.
No comments:
Post a Comment