DSXchange

Prefer importing Oracle table definitions using the Orchestrate orchdbutil facility. It is known to be more accurate in how it retrieves metadata. We are using Import, Table Definitions, Orchestrate Schema Definitions with the radio button for Database table (via orchdbutil) selected and tables we ...

Are you sure it's not a multiple of 3? Does your new data warehouse use a multi-byte character set? It is definitely a multiple of 4. The Oracle production server whose metadata can be used in DataStage just fine is NLS_CHARACTERSET US7ASCII. The new Oracle data warehouse server whose metadata fiel...

When we import Oracle 10 table metadata using Orchestrate and charset/map of UTF-8 from our production database, the field sizes are correct. When we import Oracle 10 table metadata using Orchestrated and charset/map of UTF-8 from our new data warehouse, all the varchar field sizes are multiplied by...

We have a single job where we have multiple stages to load datasets into Oracle 10. Individually each one of these pairs of stages will run, but when we get 50 in a single job we get this fatal error : main_program: APT_PMListenerPort: socket() call failed: Too many open files We can run a job with ...

In version 8.1 the icon to toggle annotations on and off is a pencil.