cancel
Showing results for 
Search instead for 
Did you mean: 

Limits on imported table's number of columns?

Former Member
0 Kudos

Hi, I'm trying to import a table in my Universe. This table has 45 columns. When I open the import functionality, I see this table in my schema, but I don't see its columns and after the importation, the table is inserted in the universe without columns...

This problem happens only with this table...

Is there a limit on the number of columns?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Do you have special characters in table columns?

More, do you have columns with data type like blob or other specific data types?

Didier

Former Member
0 Kudos

In a column there are data like "*+$XX123456" but only in one of the 45 columns...

Former Member
0 Kudos

Do you have special characters in Column name ????

Former Member
0 Kudos

No, in the case explaned above the column name is like NUM_XXXXX (without special characters)

0 Kudos

What happens if you double click on the table in the universe designer? Does it expand?

Which data source do you have?

Regards,

Stratos

Former Member
0 Kudos

No, it doesn't expand.

The source is an Oracle DB.

I have created a view on this table in Oracle and if I insert this view in the Universe, only 38 columns on 45 are imported...