DSXchange

Yes it can work on clusters. Can you be specific on which type of cluster you want DS to be installed.

If it is not able to locate an update, use a reference lookup and reject the rows. It is better to identify and remove from the stream than to let them returned as error.

You need to decode the content with reference to the column defn in datastage.

As we cannot see either of them, you are in a better position for this.

This is a 36000 feet view and method of approach to your situation. If you know which sheet will contain which columns (defn), you can include to constraint to skip rows until you find that column. Similarly, ignore as trailer when you do not have certain column entries. But you need to supply more ...

You need to analyse your records to determine the best combination. OCI is better and efficient than ODBC.

You can use ODBC stage in DS after configuring Excel ODBC in Windows.

I think you have the option of 'name contains'.

You can write your cat command in the sequential file as filter.

Use an Excel ODBC for this. Otherwise, create a csv file and use excel macros to convert to .xls.

Pass into agg stage with 'first' option for the fields.

Replace null with any non-null default value. Then pass to agg stage.

Manually looking at the sheets, how do you identify which are header, line items and trailer?

As you are attempting to check for any changes in even one column, you are in a better situation to decide this.

Also you can improve performance using hash files, checksum etc. Search this forum for more info.

Make a non-zero return value as the last line in the script - if it fails.

It says that the required column is missing. So the data has missing columns and not excess columns.