Skip to Content
Former Member
Jan 28, 2009 at 09:28 PM

Data Element Length - Restriction / Best Practice


Many databases in the market currently allows table/column names to be 128 characters long. Our developers are suggesting that 30-35 characters is the limit one should strive for.

One thought is that Business Objects cannot handle queries bigger than 64K u2013 is this true? If a query has several filters or results fields that are very long will that be a problem?

Also, is there some potential usage issue / best practice by which using a shorter name would be advantageous in Business Objects?

Our tool stack is SQL Server 2005 / Informatica 8.1.1 / Business Objects XI R2