Page 1 of 1
Importing tables to Repository
Posted: Thu Nov 30, 2006 4:22 am
by irajasekharhexa
Hi
I have some tables at oracle need to import to Datastage Repository.
Can pls tell the stpes to be followed.
Thanks & Regds
Posted: Thu Nov 30, 2006 4:35 am
by ArndW
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.
Posted: Thu Nov 30, 2006 1:40 pm
by ray.wurlod
If you have Enterprise Edition licensed, the best (most accurate) method is to import using Orchestrate, using the orchdbutil facility.