Wednesday 29 July 2009

Length of Column output to Build Table

1. Length of column = length of column in query.
2. If column is checked against a lookup then if the lookup has a bigger length the output column inherits that. NB This may include static elements in the lookup.
3. You may need to remove and re-instate a lookup to get the output column to accept a changed length. This is probably a bug in DM

THE ONLY WAY TO CONTROL FORMAT AND LENGTH OUTPUT TO YOUR BUILD TABLES IS TO USE DERIVATIONS.

No comments:

Post a Comment