DSXchange

Hi, I like to know if there is a way to drop the record if it comes as NULL from source and we load this record to a column which is defined as mandatory. Currently if the data type is number it loads 0 to that column though it comes as NULL from source. Appreciate any help on this. regards, senthil...

Hi, can someone help me to understand is there way we can avoid losing of the mapping when we import the new table structure in oracle stage. In our project they made some table level change, so we have updated the table structures by importing the modified structure but we lost whatever mapping we ...

Hi, we checked Scratchdisk space and it is not full, Not sure how to check buffer pools??

From past few days one of the job which was running fine before is getting aborted with the below msg buffer(11),1: APT_BufferOperator: Add block to queue failed. This means that your buffer filesystems all ran out of file space, or that some other system error occurred. Please ensure that you have ...

I created a job to load XML soap message to the queue. I am extracting data from the table by using Oracle Stage, Using Transformer Stage I am defaulting value for few columns that are not coming from the source table. I have used XML Output stage to convert it to XML message per row. I have used MQ...

ArndW wrote:If your integer column is set to be NULLable then it will pass on null values correctly. ...

thanks for your input, the issue is resolved.

Hi, I like to know how we can pass the default value as NULL if some integer column comes as NULL from source. Currently when we load value to an integer column, it get loaded with '0' if the source value comes as NULL. The only option i could see now is to check for spaces(blank) using trim functio...

keshav0307 wrote:try using this query:

INSERT
INTO
<Schema_Name>.REF_SAP_GL
(X,Y,Z)
VALUES
( :X, :Y, :Z).

thanks, it worked after appending the schema name.

ArndW wrote:"u" is not a valid English word, try using "you".

If you activate a reject link and output that to a file, what is the SQL error code you get? ...

I am getting the same error message after activating the reject link

ArndW wrote:Are you writing to the same Oracle instance? ...

Yes, I am writing to same oracle database, but to a different schema.

Let me know if u need any other details.

Hi, We are getting the following error message when we run the job in system test. We are not experiencing any issue in development enviorment and the same job runs fine in development enviroment. The only difference between development and system test is the version no. Development version is 7.5.1...

Thanks for the reply, is there any option in 7.5 using which we can implement this range lookup. One option is to use joiner/lookup and use a filter to apply the conditions. I like to know if there is any other option.

Thank you very much Ernie for your valuable input.

hi, I like to know if there is a way in which i can apply a condition in joiner stage. We need to pass the date from source and get corresponding value from lookup stage based on date between start and end date. Start and End date are the columns in lookup table(oracle stage). Similarly like to know...

Hi,

I tried using a remove duplicates stage to pull only the last row, it works, can anyone help me is there any other efficient way to doing this the entire logic?

regards,
senthil