DSXchange

My guess is that there's a little more action happening between the ORAOCI stages, potentially a hash file that's getting too big or something else. We need a little more info.

FTP plugin is using FTP, which is not SFTP. If you want high-performance data transfer across a network that is secure, then use a secure command line program with compression logic.

You're not the original poster, you've hijacked that persons thread. So, to speak to their original post: I checked the generated SQL in the Insert stage and it shows the following (TO_DATE(:15, 'YYYY-MM-DD HH24:MI:SS')) whether I am using the Generic Date to ORA or ORA with Time transformation Gene...

Ascential/IBM would be preferable acutally. Why? You're posting on the DSXchange, obviously you've found the need to go elsewhere for support. You've got 20K+ questions answered here, supported by folks who've been using the tools for 8+ years, some of whom are former VMark/Ardent/Informix/Ascentia...

ummmm, sounds like a bug to me.

Dates are REALLY easy, you don't have to do most of the manipulations discussed on this thread. 1. Put all dates into ISO format YYYY-MM-DD during transformation. If you have a NULL value, THAT'S OKAY. However, whenever you manipulate your date into ISO, make sure you do it correctly. The time porti...

Externally pathed hash files do not work with most TCL commands unless you've used the SETFILE command with them. Why clear it when you can just delete it? Is it because you're not wanting to incur creation overhead because you have a minimum modulos? One of the best reasons to use externally pathed...

Use indirection to put the password into the input stack.

What probably happened is that the abnormal termination left a job process connected to Oracle. Whenever a job aborts and was talking to a database you MUST check to see if any zombie processes are still out there. The next time the job runs it might see that zombie process and confuse itself and do...

There are a couple major, job impacting changes from release 4 upwards. Link ordering was changed, therefore all reject links have to be the last in the order or they don't work. Functions changed to arguments being passed by reference, not actual value. Any Function that changed passed argument val...

Write a shell script to line count (wc -l) the file and then issue head -n??? where ??? is the result from the line count operation minus 1. Put this in the filter portion of the sequential stage.

Grant it to any roles or users you deem necessary.

Compile your function in Oracle, make sure it's available to all users who require access by granting. DataStage doesn't know the difference between an inherent Oracle function and a user created function. Just use your function in your SQL statement wherever necessary. If the function is part of th...

It will impact your ETL, depending on the type of indexes, tables, the loading method, and the nature of the data. Partitioned tables with global indexes will have severe performance impact to ETL, because partitioned loads send their data directly to each partition using direct path sqlldr. Global ...

Take a look here:

http://www.dsxchange.com/viewtopic.php?t=85788