Importing tables to Repository

irajasekharhexa · Post by **irajasekharhexa** » Thu Nov 30, 2006 4:22 am

Hi

I have some tables at oracle need to import to Datastage Repository.
Can pls tell the stpes to be followed.

Thanks & Regds

ArndW · Post by **ArndW** » Thu Nov 30, 2006 4:35 am

How you do this depends in part on how you have established connectivity to your Oracle instance.

If you have established ODBC connectivity then go into
Manager -> Import -> Table Definitions -> ODBC Table Definitions

If you have direct connectivity then Manager -> Import -> Plug-In Metadata Definitions then choose Oracle.

ray.wurlod · Post by **ray.wurlod** » Thu Nov 30, 2006 1:40 pm

If you have Enterprise Edition licensed, the best (most accurate) method is to import using Orchestrate, using the orchdbutil facility.