need mapping for clearing staging area?


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 regards
Teradata Employee

Re: need mapping for clearing staging area?


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.