Home Forums Database Design Design Ideas and Questions Field Sizes in Staging database : all varchar(2000)? RE: Field Sizes in Staging database : all varchar(2000)?

  • April 13, 2012 at 4:30 pm

    #1473582

    devereauxj (4/13/2012)

    NEWBIE to DW : the IT Manager wants to use varchar2(2000) for all fields in all tables.

    In general DWH Staging tables are modeled after the OLTP tables from where they are going to source the data.

    Is it wrong to use varchar2(2000) for all non-numeric columns on staging tables? well, it is not elegant but it will work. You may want to let IT Manager know - very politely - that max size for varchar2() moved from 2,000 to 4,000 around Ora8i.

    _____________________________________
    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.