Hanu

• Jun 8th, 2006

 

Are u talking in the DW or in Informatica?

If u want any staging area, dont create staging DB. Load data directly into Target

Hanu.

Prasad

• Jul 14th, 2006

 

hi,

this question is logically not correct. staging area is just a set of intermediate tables.u can create or maintain these tables in the same database as of ur DWH or in a different DB.These tables will be used to store data from the source which will be cleaned, transformed and undergo some business logic.Once the source data is done with the above process, data from STG will be populated to the final Fact table through a simple one to one mapping.

vikki_gupta2003

 Profile Answers by vikki_gupta2003 

• Mar 14th, 2007

 

Hi,

1)At DB level we can simply DROP the stagin table.
2)then Create Target table at DB level.
3) Directly LOAD the records into target table.

NOTE: It is recommended to use staging area.