How to create the staging area in your database

Client having database throught that data base u get all sources
  • Interview Candidate
  • 3
  • 3005

Showing Answers 1 - 3 of 3 Answers

Chandran

  • Nov 2nd, 2005
 

If You have defined all the staging tables as tragets use option Targets--> Generate sql in warehouse designer

  Was this answer useful?  Yes

Gokulnath_J

  • Nov 8th, 2005
 

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 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 the Warehouse Designer tab.

  Was this answer useful?  Yes

kishore

  • Jan 29th, 2006
 

creating of staging tables/area is the work of data modellor/dba.just like  " create table <tablename>......"  the tables will be created. they will have some name to identified as staging like  dwc_tmp_asset_eval.

tmp-----> indicate temparary tables nothing but staging

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions