DSXchange

Several project teams are extracting data from the same Universe tables currently in production. One of the teams is proposing to add columns to Universe tables being utilized by other systems(datastage jobs). Within Oracle, the metadata for the systems not using the 'new columns' would not have to ...

What is the best method for performing bulk loads into Oracle ??

Where are the Oracle Database UserID Password Schema entered
in the Oracle_Express_Load stage ? Upon reading the help, it refers
to DataBase name (which I'm assuming is the Oracle load), but does not
refer to the entries for UserID Password Schema .

Oracle | 98hits Oracle>>>>Transformer>>>>>>flatfile 100 0 Job performs oracle extract (100 rows), transformer performs single key lookup into another oracle table (gets hits 98 times) , the transformer has a link.NOTFOUND constraint, which means it should continue to the target for 2 rows. The probl...

If a pivot stage inputs a single row containing Jan, Feb, Mar, thru Dec sales data, is it possible to include month column identifier in final target with the corresponding sales amount. Input: Sales Key, JanAmt, FebAmt, MarAmt, DecAmt Output: Sales Key, "Jan", JanAmt Sales Key, "Feb&...

Situtation: Within Oracle date field, when date is todays date then process sequence, otherwise wait 10 minutes and repeat cycle. Need design opinions.

It appears that the only method for loading is into a timestamp. I don't believe it's possible to load only the date. The OCI9 stage always attempts to load the DATE as TO_DATE(:4, 'YYYY-MM-DD HH24:MI:SS'), which is not a DATE field, but is really a TIMESTAMP. No, a TIMESTAMP is a completely differ...

It appears that the only method for loading is into a timestamp. I don't believe it's possible to load only the date. The OCI9 stage always attempts to load the DATE as TO_DATE(:4, 'YYYY-MM-DD HH24:MI:SS'), which is not a DATE field, but is really a TIMESTAMP. As previously stated, I'm getting error...

installed code: oconv(iconv(NewDate, "D-DMY"),"D-YMD[4,2,2]")

I'm still getting error: Value treated as NULL
Attempt to convert String value "2002-12-01" to Date type unsuccessful

Target field is Date - length of 10

Does anyone know exactly what to code to load a char date into OCI9 datatype. I'm getting the following error:
Attempt to convert String value "12/01/2002" to Date type unsuccessful

Your answers were right on. Thanks

Created Oracle table with single column, datatype is long. Imported metadata in manager. Created oci stage, used builder to build sql and columns. Getting the following error: CopyOfZPILOT_ORCL_TO_FLAT_PartialRun..Oracle_OCI_112: OCI has fetched truncated data CopyOfZPILOT_ORCL_TO_FLAT_PartialRun..O...

The job itself must communicate back to the sequence that the sequence must not continue with the remainder of the sequence. How is this done?

File is received from external server, now check date on file to determine if current. If data not current, how do you quit current job and current sequence.