DSXchange

In a PX job, I am trying to add a number (days) to a date and come up with a new date. For example, I want to add 185 day to date 2003-05-24 and come up with a new date. Can any one help?

Thanks in advance.

This porblem has been resolved. It turns out that we played with the partition of the lookup file set and that caused the cause the code it's looking up for missing from the partition and failed the lookup. Basically, the safe way is not to parttition the lookup file set if you do not have to.

Because the log msg. says "50% processed". I added the peek as you suggested. The job finished processing total of 1008 records with 231 rejected. The rejected records all have the code "O". I checked the lookup file set and it does contain "O" there. Do not know why th...

I have a foreign key lookup parallel job. I use the lookup file set to lookup for keys. However, the lookup failed after processing up to 50%. I got the massege: Failed a keylookup for record. Then it gives another msg: Operator's runLocally() failed. Anyone out there have any idea what could cause ...

I have done all of that, however, we still need to define a join in the lookup stage to specify the join in the lookup on the keys defined in the lookup file set and the main stream, right? I could not create this key expression there. Help please! My understanding ... You have to definie the Key wh...

Yes, I have declared a key in the LookupFileSet and a key in the main flow stream. I can see the key field is bold, but the the key exression next to it was greyed out. When I right click there, the option "create key expression" or something like that was also greyed out. I still can not ...

I use a Lookup stage to lookup from a Lookup File Set Stage. When I opened up the Lookup Stage, I found that the "Key Expression" for the key field of the lookup file set is greyed out. It's not giving me any error msg. and the job passed the compile. Why is it greyed out? Do not we have t...

Hi, I looked into the ORAOCI Bulk Load and Oracle Express Load. Under Load Mode or Load Action, I did not see "Upsert" selection there. Can you set this up in DataStage? Thanks. the only solution about this problem is : using Upsert mode Loading in Oracle Table and perform function to_clob...

We are going to use the ORAOCI bulk load to load the sequencial files. In the file there will be some records to be inserted and some records to be updated. We will provide the flag for insert or update in the input file if needed. My question is: for the ORAOCI stage in the DataStage, is it doing i...