simple - staging question

[vsi]

Hi ,

I have a simple question - I know that we need to stage immediately after extraction.

I have got the reference tables which are very easy to implement i.e all ETL all in one single job.

Do I need to stage such kind of reference tables as well immediately after extraction?

Thanks

[chulett]

You don't "need" to stage, it is however a Best Practice. But like any rule, it doesn't need to be slavishly applied 100% of the time. Depending on the nature of the job, volumes, restartability, etc you could skip the stage part.

And by 'stage' in this context you mean 'land', as in to a flat file, yes?

Hmmm... I guess since you asked a 'simple' question I should have stuck with a 'simple' answer, so here you go. No.

[vsi]

Thanks Craig