DSXchange

Hi All,


Could any body tell me the difference between QualityStage plugin in server job and Data Quality stage in Parallel jobs.


Thanks in advance!!!!! :D
DS29

Add a suitable WHERE clause. Get the most recent update time from the target and use that as a job parameter, which you add to the WHERE clause. ... Hi Ray, I understand your suggestion but my question is how to read the the most recent update time from the target and apply as job parameter. Could ...

Hi Source is Oracle database and Target is a sequential file.

our reuiremet is whenever we run the job, it should fecth only delta (changed record) based on the datetime field in source

shaimil wrote:Could you clarify whether the source is a db or sequential file

source is db

shaimil wrote:Could you clarify whether the source is a db or sequential file

Hi All,

I am storing some information from my source system to a Sequential file/hashfile.

Could anybody let me know how to read the has file in DS server job?


Thanks in advance.

Hi Ray, I wanted to implement incremental load in DataStage. My case is some things like this- Let suppose my source table has 10 rows and Target is blank initially 1) In first laod job should laod all the rows from source to target. 2) In second run onwards it should fetch only those records which ...

Can anybody tell me how to read data from seq file to implement this logic Sorry, my intention for last_execution_date was with current data values. now with same concept, interpret like below. suppose you have a 10 records of for date 31-12-2006 in source, you executed the chain and you store the 1...

1.store your last execution date either in database or in sequential file, during your next execution scan for this value and have select on your source table with condition of Datetime > last_execution_date, you will get only those records which are updated or newly inserted. 2.you can scan for ma...

Hi All, I wanted to implement incremental load in DataStage. My case is some things like this- Let suppose my source table has 10 rows and Target is blank initially 1) In first laod job should laod all the rows from source to target. 2) In second run onwards it should fetch only those records which ...