How many staging areas are there in your project? Recently I have asked this question is there number of staging areas? Please briefly explain it , Thanks in advance.

Showing Answers 1 - 5 of 5 Answers

Arush Rastogi

  • Nov 13th, 2006

There are 4 different staging areas in a project these are -

1. Extract

2. Cleansing

3. Transform

4. Load

  Was this answer useful?  Yes


  • Feb 8th, 2007

only 1 staging area. You can use it for extracting, profiling and whatever. Its a bad idea to have individual stating area for each of those operations.Mike

  Was this answer useful?  Yes

Noel Lastra

  • Feb 22nd, 2007

HI Guys just want to clarify, this staging area you are referring to is the actual location of your file and records right ?  This means in unix it could be a folder location like /project/inbox/sst/stage.   If this is the case then it is better to have a different location folder for each staging area prior to the final loading to Target.  But you need to write a shell scripts that clean or archive the area after use.

  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