All Forums UDA
shivareddy 3 posts Joined 04/09
10 Jun 2009
need mapping for clearing staging area?

HI ......,How r u? I hope ur well &good.Actually how we can design a job for clearing staging areas automatically with out user intervention?If u knows, please let me know….. Thanks in advance…….Best regardsshiva

Adeel Chaudhry 773 posts Joined 04/08
10 Jun 2009

Hello,There can be many ways to do that, you don't necessarily require a separate job for that!For example, whenever you load data from any particular staging-table and there is no dependent job left to run on that table, you also clear-up that table's data.Primarily, you need to know the flows of execution, all the dependent jobs on all the staging tables, to make effective plans on clearing staging tables.If you don't want to do it this way, one approach you can always follow is, stage the data, load all of it to DWH and then clear the whole staging area.HTH!Regards,Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.