Data extracting issue from oracle

[DWH-M]

I am facing problem while extracing the data from using ODBC enterprise. I have imported the columns using the table definition.
but when i try to check the data using view data button i am getting an error like data type not supported and getting like ODBC process meta data not available in data base. When i have imported table definitions for the column i have got NVarchar, Nchar, Timestamp, decimal,biginit,longnvarchar.

Please let me know the solutions.

[chulett]

The preference would be to use the orchdbutil command to import the table metadata as that is the most accurate way for PX.

[ray.wurlod]

Import > Table Definitions > Orchestrate

will invoke orchdbutil when that particular option is selected in the dialog - you don't need to learn the intricacies of the orchdbutil command itself.