DSXchange

[quote="ArndW"]Since both functions do different things you cannot compare them that way. ...[/quote] Hi ArndW, i dont think they do different things. they both do the trimming, dont they? :) if i am wrong, could you elaborate. but i was asked about this once by comparing it with Trim. tha...

hi, is there more advantage in using TrimLeading() function over just using Trim() function. Considering the extended options in Trim function itself like TrimB or Trim(str,'', 'L') etc, I am just curious if there is any additional benefit Trimleading could offer. I searched the forum but couldnt fi...

I am trying to get different physical partitions of data so that I can kick off the loading part in parallel. I could have achieved if it was sequential file. But we are using Dataset for the storage. So, I am working on splitting the dataset with some suffix at the end of small Dataset files. In my...

hello All, Is it possible to split the Dataset file (just like Unix split)? There is a requirement to split the dataset in small datasets and use the split dataset for the loading process. Any inputs on this appreciated. I tried looking for the available options with Orchadmin and osh commands. I co...

hello everyone, there are some files created by Datastage at some specific locations. is there a way to automatically clean up the files or should have been there any option during server installation? the location /opt/IBM/InformationServer/Server/Scratch has some files like c51node1.00000000000000...

Hello All, We are trying to use the Notification stage with the distribution mail id as the mailing list. The distribution id has been added with company domain id (@bankofamerica.com) and other external ids. For e.g 1. abc@bankofamerica.com 2. mno@offshorecompany.com 3. xyz@hotmail.com 4. def@yahoo...

Hello all, There is some strange pop up message in many of my jobs due to the usage of shared containers. Whenever I try running the job in Designer, it gives the message below "The following shared container(s) have been modifed since this job was compiled To continue, you must recompile the j...

i thought of one of your suggestions and tried that too - decreasing the commit level to 1 row. it doesnt work. even if it works, it is going to create another database menace. this issue is kind of weird. i have not faced this in oracle. it is quite normal that there are some updates which may come...

Hello all, I have a job which loads the data into DB2 database. There is a field as dml type to tell whether to 'Insert' or 'Update' the record. In the transformer, I am using that flag to send to the target stages. The problem I am facing is: There are situations like there are couple of records co...

I am not resetting it manually. Since the sequence does that part, there isnt much of the information. The following is what I see.

Resetting Job BuildNote.
Resetting stage BuildNote..Transformer_2.
Finished Resetting stage BuildNote..Transformer_2.



The look up table volume is about 99 million.

We have about 4 jobs which use the lookup stage on some huge tables. Almost every week, one of those 4 jobs fail with the same generic error "Abnormal termination of stage BuildNote..Transformer_2 detected". Those jobs don't have anything complex. Just a source, a lookup and a target. I am...

I have had problems with the compilation of the sequence. If you are looking for work around, you can try taking a copy of the sequence and deleting the old sequence and then compiling the new copy. It could be the job or the status corrupted.

Hello All, I was trying to find some routine or function to validate the incoming source DATE values. Sometimes the source is deriving (from other date columns) and sending invalid dates like 31-sep-2007. But there is no 31 in September. Is there any function like IsValidDate in datastage or it has ...

I guess you are looking for the generated sql in look up.


SELECT "CLI_COV_CODE","CLI_LMT_DED_CSL_IND","CLI_CLM_NO" FROM "T_CLAIM_LIMIT_DW" WHERE "CLI_COV_CODE"=:1 AND "CLI_LMT_DED_CSL_IND"=:2 AND "CLI_CLM_NO"=:3

Hi, When oracle stage is used as the look up, it does not try matching all the look up/key columns. E.g Source: Key1 Key2 Key3 1 A X 2 B Y 3 C Z Look up: Key1 Key2 Key3 1 A P 2 B Q 3 C Z I am expecting only the last row to be matched (all the 3 columns are linked in the transformer) but instead it i...