DSXchange

Hi,
I want to simulate the following logic in 1 transformer:

If data is found after hash1 lookup then
move data from hash1 to output
Else
lookup hash file 2
If data is found in hash2
move data from hash2 to output
Else
move 'not found' to output
End If

Any suggestions? Thanks.

This error message was generated when a column was truncated during insert to the table.

Thanks for your help.

Hi Roy Thanks for your help. The warning I am getting is an Oracle warning and it appears in an DataStage INFO message (not a warning as I have probably described). However, it is still a warning - It reads like this: <date><time>info<program name><The column(3) in row(2) cannot be converted. See ne...

Hi, I am running a DS server job from HP UX and at the end of the run I get the return code = 1 Job Status : RUN OK (1) When I checked in the DS Director, there were few Oracle warnings. My question is how to accurately determine the job status and identify that there are Oracle warninings when runn...

Good, thanks.

OOPS! You are correct.

However, after I corrected the mistake, I expected to get the job name followed by some numeric value for SJobInvocationId - But I only get the job name - Any suggestions?

I need to make some sequential files in the job have unique names. Unique in the sense that allows multiple copies of the job to run at the same time and also unique across different jobs. I tried to use something like this: #DSJobName#DSJobInvocationId# But the macros are not working on the file na...

Thanks for your help.

I am reading data from a fixed lenght record with fixed length columns. Even though I define each column as Varchar in the input Sequential stage, and as Varchar2 in Oracle target table, I still get trailing blanks. Since I have so many columns in input, I don't want to explicitly call trim - Should...

Great - Thanks

I have a hash table that has a composite key (the key is composed of 2 columns c1 and c2) I want to specify a lookup conidtion like this: C1 = value1 and (C2=Value3 or Value4) The first part is trivial. The part 'and (C2=Value3 or Value4)' is where I have a problem I assume that the logical operator...

Guys, you are very helpful. Thank you all very mcuh. Chuck, I tried one of your tools, I don't know where to put the search string - For example, I tried to use a string like 'Transformer' in variable StagesTypesOfInterest (assuming this is the search arg) and ran this against the tool's .dsx file b...

Hi All, I am maintainig a datastage project that has sequential file stages and oracle stages defined in jobs and not in manager. As a result, I can't use the manager's "Usage Analysis" to track where a file is created from or a table being used. Is there a way track usage in this situatio...

Can some one pass me some links so that I can know how to get training and how to get certified in DataStage.

I checked the vendor's web site but could not locate the topic....I am assuming there is certification for DataStage...

Thanks.

Ekareem

Thank you all for your help.