Staging Area, copy tables

View previous topic View next topic Go down

Staging Area, copy tables

Post  braken on 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

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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