DSXchange

ray.wurlod

What are the data types in the Oracle table? Is the date format correct for your Oracle instance? What is the SQL being executed (this is reported in the Oracle stage)?

ray.wurlod

Change the constraint on link #1

Code: Select all

(matched record) And (1=2)

Then no rows will go out link #1

ray.wurlod

Are there any warning messages (particularly from the ODBC driver) in the job log? What load mode are you using?

ray.wurlod

Not possible. Technique 1 was specifically "add a dummy column". Use a column generator stage upstream on each input link to the Join stage.

ray.wurlod

Have you selected "do not checkpoint run" in the Routine activity to force the Routine to be executed even on a restart?

ray.wurlod

I'm still curious about what "not working" means in the context of the "/" operator. Div() is integer division, but "/" is not.

Code: Select all

AsFloat( DSLink3.INSTR_SET_HRS) / 10.0

ray.wurlod

480MB is not a problem. VarChar(999) may be, since the default maximum key size in a hashed file is 768. Hashed files need to be 64-bit only if there is any likelihood they will exceed 2GB in size. The size of the VarChar does not have any impact on storage in a hashed file; only the required amount...

ray.wurlod

The cat command will use hardly any resources at all. The files are already on disk. Output from the cat command is not written to disk; it becomes the input to the sequential file stage. If you like the effect is that of

Code: Select all

cat files* | DataStage job

ray.wurlod

Your metadata don't match what is actually in the File Set.

ray.wurlod

Technique 1.

Technique 2 is a UNION ALL, not a JOIN.

ray.wurlod

Rot. You get KEY columns (unless you have a Lookup File Set on the other end). In this context this means "search key", not "primary key".

ray.wurlod

You have APT_DISABLE_COMBINATION available.

ray.wurlod

If you name a file it will come into existence. Check the row count on the reject link and delete the file, or check the size of the file and delete it if it is zero.

ray.wurlod

You don't. Read the chapter in the manual about the Folder stage.

ray.wurlod

WHAT about DataStage?

Every DataStage job has its own log, which you can view in the Director client.

If you design your job to handle rejects, you can design it to do whatever you like with them. This includes reporting on them.

Search found 53125 matches