Where the import put my Schema ?????

[Peytot]

Hi Everybody,

I import the definition of my Oracle Database in using : Table Definitions/Orchestrate Schema Definitions and after I choose Database table.

But when I import the structure in DataStage, it translates Number by BigInt or Decimal(38,10).

I would like to modify my schema but I don't know where the import put it on my Unix server

Regards,

Pey

[jhmckeever]

Hi Pey,

In the repository you should be able to see your imported table under Table Definitions -> Oracle -> {DBName} -> {TableName}

If you open that you can modify the definition on the Columns tab, or you can get direct access to the schema version of definition by clicking [Show schema] on the Parallel tab. You'll need to decide how you want Oracle's Number represented in DataStage.

Hope this helps,
John.

[Peytot]

Thanks John,

But where Can I find this option :

you can get direct access to the schema version of definition by clicking [Show schema] on the Parallel tab.

Pey

[ray.wurlod]

Go to the Table Definitions branch of your Repository view (in Manager or Designer client). Find the table definition into which you performed the import (this was under your control, and reported to you as part of the import process).

In Manager perform a Usage Analysis to make sure that this table definition is not used in any jobs where changing it might have some deleterious effect.

Open the table definition's properties, and edit the Columns grid to get the data type correct.