devereauxj (4/13/2012)
the IT Manager wants to use varchar2(2000) for all fields in all tables......Manager's idea is to make sure we capture the data in staging exactly like it is in the flat file.
Ask manager if he plans to user varchar2(2000) also on the core FACT and DIM tables - if not, how is he/she planning to ensure staging varchar2(2000) fits into properly defined columns on FACT and DIM?
Again... Staging columns datatype and lenghts should be modeled after the source system and never ever larger than the definition in core FACT/DIM tables.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.