DSXchange

Treat this as a parent/child problem. Insert the parent records into the base table and the child records into the nested table. You may like to use a Distributed Transaction stage.

Business Glossary can only ever be represented as Terms and Categories.

BI Reports is for imported BI reports, imported via Metadata Asset Manager or Import/Export Manager.

Do an export from Business Glossary into CSV file to see the exact format required. Then re-organise your Excel information (record macros so that it's repeatable) so that it's in the correct format. You probably need to handle categories and terms in separate worksheets, and combine them subsequent...

Use Code tags to hold the alignment.

The hashed file will be looked up for every row coming in from Latest_Batch. It should return its one row in each case. Is this not what you require?

Try changing the hashed file type from 30 to 2, with a separation and modulo of 1 each.

Are there SQL extensions in Oracle for accessing the nested tables? Something like the UNNEST keyword in UniVerse?
If so, you can probably supply user-defined SQL to take advantage of the nested table functionality.

Not in all countries it's not.

For example in Australia (a) it varies state by state and (b) it's a political decision.

They seem to have changed SDKSequences from a static hashed file into a dynamic hashed file. But the task remains to migrate the hashed file, and to ensure that a VOC entry for it exists in the new project.

DataStage, when converting Decimal to String (for example for display or writing to text files), adds leading and trailing zeroes in accordance with the precision and scale settings.

The second argument is length, not finishing position. Try:

Is the column nullable in Oracle, and is it marked everywhere in your job as Nullable = Yes ?

Show us the expression you used to extract the five characters.

I suspect that you have used an incorrect syntax.

Specifically you need the Information Analyzer Project Administrator role to be able to create a project in Information Analyzer.

Suite Administrator role does not give you this permission. It does, of course, give you the ability to assign this role to yourself.

No. And no.

Research the definition of the Timestamp data type.

And then it should be a Server job.

Some sites do not permit the use of Server jobs. It's political or just an uninformed decision.

Not in DataStage, but you can probably interrogate the timezone environment variable (usually TZ).