DSXchange

It is a trick question. An incremental load is based on only selecting records in the source which have changed. You can do that without keys. All you need is last updated field in the source. What to update in the target may require keys. I also believe that it is trick question. That means if we ...

If you trust your load portion of ETL, you can compare yesterday's full load file with today's full load file to identify inserts, updates, and deletes. Look at the unix "comm" command to compare your load files. Thanks for your tips Though I can indentify changed records using unix utili...

This job is runnig fine while loading into db2 udb on windows environment which is same as DS server.
and it does not give any null related error.

It throws error only while loading into db2 udb on linux enviroment.

I am getting different error while loading data into db2 on linux in the same job. "[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]OBJECT COLUMN TBSPACEID=2, TABLEID=635, COLNO=1 CANNOT CONTAIN NULL VALUES IN UPDATE OR INSERT SQLSTA...

Basically what you want to do with this?

if code=B or C then what output you need

Anyway go with Amit_111 approach

This is one of the interveiw question. Source tables/files does not contain any key field. How to implement incremental load in the target tables? I was guesing using unix shell script commands like compare and other commmands, it be can be possible. Any other tips/solution would be a great help. Th...

You source fieled is decimal(15,2).
You are performing sum operation(altering value) on this filed, DataStage is expecting the resultant value will be greater than big amount value of the source filed. I believe that is why datastage throws warning.

Welcome

Not Datastage Websphere, it is called IBM WebSphere DataStage in version 8.0 onwards.
Ascential was replaced by WebSphere in the new version of datastage 8.0

You can also put the constraint in the transformer like

and put derivation of Flag as 'Y'

It will pass only matching rows.
Then update only these rows at target table

Thanks

Hello DS experts,
Any other suggestion/idea for this issue?
I am still stucked on this.

Also check the date format at the target database in both windows and unix environment.
As per target date format u need to customize the date() function accordingly.

Also check the date format at the target database in both windows and unix environment.
As per target date format u need to customize the date() function accordingly.

First check the date format in the target database.

Try to insert one record directly with date '01/01/2005' using sql command, see the output.

I believe your target table has different date format.