DSXchange

how to implement Insert,Update or Delete logic in datastage?

What is Project Estimation?
What are the steps involved in project estimation..?
Please kindly clarify my doubt.

The below rule how to implement in datastage? Transform record as per INSERT process type. Lookup Acct where EXPY_date = 'yyy/mm/dd' IF not found THEN INSERT record ELSEIF any of DELTA VALUE columns has changed THEN UPDATE record as per UPDATE process type INSERT record ELSE Perform UPDATE CLOSE ENDIF

In how many possible ways can call routines in datastage?

How to call routine in datastage?

one more is

how many possible ways can call routine in datastage?

what is meant by Initial Load & Delta Load..?

when does it come into picture in Datastage ?

what is meant by linked sort..?

any diff b/w sort & linked sort....?

while loading dataset how many files are created internally?

and what is default path of dataset ...?

any body tell me the path of configuration in datastage..?

I have a datastage job which is having 900 records.

my qst is the job has been aborted after 400 records. i want to start from 401 record ?

how to do that..?

_________________

I have 100 records in source and 20 matching records in refernce table.

how many records did u get in target?

I have datastage job which is having 1000 records.my qst is

my job is aborted is after 500 records. iwant to start from 501 record.

how can u achieve using transformer stage..?

how to implement the below rule in Datastage?

i have a column "TransDate" the datatype is char and format is yyyymmdd

yyyy should be start with "20"

mm shd be value 01 through 12.

how to implement the below rule in Datastage?

i have a column "TransDate" (yyyymmdd)

yyyy should be start with "20"

mm shd be value 01 through 12.

Please provide solution for above query?