DSXchange

Ravi,
The logic provided above is fine. It seems the issue is with the way you are partitioning the data. Try doing a hash partition on deptno.

We have Datastage Version 8.0.1 installed. However its key got expired few days bacak. We got the new license key from IBM yesterday. Please let me know the process to update the licencse key and also whether there will be any impact on the existing jobs.
Regards
Vikas

Hi,
Sort file1 using ENO and file2 using SAL.Using column generator create a Key column for both these file and then join these.Simply remove the key column in the next stage.

Hi,
If it aborts after 50 warnings then set warnings limit to "No Limit" on The Options tab in Director.Try posting full error details for better answers. ;-)

Hi,
The message "**VIEWDATA ROW LIMITER HIT** "comes up when the file you are trying to view is empty.Please check that your skip count is "0" and Period "1" while viewing the data.

Hi, Other way of doing this can be as: Read character by character of the string and then use this derivation to replace any other special character to space: if index('65|66|67|68|69|70|71|72|73|74|75|76|77|78|79|80|81|82|83|84|85|86|87|88|89|90|97|98|99|100|101|102|103|104|105|106|107|108|109|110|...

Hi,
This may be due to 2GB limit of your OS. Check whether the intermediate files being created are exceeding the limit. ulimit command can be used to check that.

hi,
As this is a ksh script, just confirm that you are using 'ksh -x' in the Command text box under ExecCommand Tab of the Execute Command Activity and #HOM_DIR#/sample.ksh along with the parameters your scripts needs in Parameters text box.

Hi, You can perform remove duplicate functionality in a transformer stage.In the transformer Stage select Hash partitioning on the Key you want to perform remove duplicate. Then write a simple logic in the stage variables to check if the last row had the same key value as the current one and use thi...

Hi,
Check the space available on the nodes.

Hi,
Apart from the visual check, you cen get this stat from the log files in the DS Director.You need to set the enviornment variable:APT_DUMP_SCORE
to "true" for this.

Hi
Just try setting the nullable property of the cloumn to "Yes".Hope so this would work.

What's different between the servers? ...[/quote]

Hi,
The difference may be one of them:
1) Hardware configuration: The other server would have less disk/swap space/processing power.
2) Other Jobs may be running at the same time,resulting in resource sharing.