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