DSXchange

Try this

first load the existing records into the hashed file. next job. refer the hashed file with source have a variable like if Not(DSlink1.NOTFOUND) then 'Y' Else 'N' in the transformer stage. have a constraint in transformer for 2 links For'Y'(UPDATE) and 'N' for(NEW) design should look like below hashe...

SELECT TRUNC(SYSDATE)-1 AS LAST_MONTH_END_DATE FROM DUAL in oracle

DSGetStageInfo(hJob,stagename,DSJ.VARLIST)

Datastage user has write permission in the project directory.

At the end ADD Project process using Datastage adminstrator Client.

Check Datastage is setup correctly in Project UV
(Subroutine Failed to Complete Successfully(30107))

the above error

executing the below command in datastage server as dsadm user.

dsadmin -createproject test -location /usr/datastage/test

below error occur.


ERROR: DSR.ADMIN: Error creating a schema

Status code = -135 DSJE_ADDPROJECTFAILED

ERROR: DSR.ADMIN: Error creating a schema

Status code = -135 DSJE_ADDPROJECTFAILED

below link may help you.

viewtopic.php?t=97681&highlight=
viewtopic.php?t=118685&highlight=

Sort the data by using sort stage(join key column) and derive the key change column.

Have a constraint (keychangecolumn=0)in transformer before writing the dataset.

We can avoid one-to-many relationship.

how to call parallel job functions in schema file?

like

Mathematical
Null Handling
Type Conversion
String Functions

e.g to convert from string to decimal

12345 to 123.45

try this

convert(@FM,'|',Field Name)

having a file which contains a numeric digit.
how can i extract from the file in job sequence

my design is

database--------file

from file i have to extract and pass into loop