Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Staging Area, copy tables

Go down

Staging Area,  copy tables Empty Staging Area, copy tables

Post  braken Tue Nov 27, 2012 2:51 pm

Right now, I am dropping tables and creating them as select ...(whatever I want). I am doing it to get to the transformation part asap, but I really have doubts about this. I could trunc(table) but then what if the structure changes? So, I am just trying to figure out the best method. I am using oracle warehouse builder, and what I am assuming might be best is to create staging mappings, that will just be a 1 to 1 copy. The downside to this is that I would have to create each staging table to extract to, but it would allow syncing of them if the source table changes. I am curious as to what you think?

braken

Posts : 2
Join date : 2012-11-27

Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum