i am facing below error while creating a table using "create table" statement.
Executed as Single statement. Failed [34 : HY000] [AsterData][ASTERJDBCDSII](34) ERROR: insufficient information to determine the distribution key ()
Please help in resolving the error.
i am using teradata studio 14.10.
kk, What type of table are you creating, FACT or DIMENSION? Please refer to the Aster Database User Guide, section Distribution Keys and Rules for distribution keys that might help. The document is on the Teradata Information Products web site (http://www.info.teradata.com/AsterData/eBrowseBy.cfm). You could also post your question to the Aster Forum.