DSXchange

How about taking this step-by-step. Modify your job to put an output link from your Oracle stage directly to a flat file and in the Oracle stage options mark "Output reject records" as "true". After the run do a "cat -v YourRejectFileName.txt" to get both the SQL error...

Is that resolved ?

Hi All, I have two fields to concatenate A=(011)7171361 B=(o) C=A:B When I do Concatenation of A:B iam getting the value as C=A(B value is not concatenated) But when I do C=B:A this is working fine. Do some one has clue why this is not working for C=A+B Iam writing the data to a DataSet Regards Che...

not in same job with 2 different Oracle enterprise stage. If you are bound to use that then make sure the where condition contains enough constraints to leave the current records. upsert mode is OK to be used with SCD. Before I can suggest any thing you need to answer the question asked by miwinter...

not in same job with 2 different Oracle enterprise stage. If you are bound to use that then make sure the where condition contains enough constraints to leave the current records. upsert mode is OK to be used with SCD. Before I can suggest any thing you need to answer the question asked by miwinter...

With the SCD stage, I'm supposed to use the insert/update mode normally

get a trace from oracle, i suspect there are some other queries blocking the update query. I performed few tests on oracle 10g with Oracle Enterprise Stage earlier with the similar number of records than you, below are the results in short: 2 oracle stages one with insert/load and one with update i...

miwinter wrote:What are the target database and stage being used to insert/update? I haven't got access to v8 as yet, so apologies if the SCD stage is the stage being used to do the write.

It is Oracle 10g with Oracl Enterprise.

miwinter wrote:

Join columns were indexed?

Does this mean the columns in the 'where' of your update are indexed?

Yes

Hello all, When using the insert/update method I get ridiculous performance on volumes over 5000 records. I have a dimension over 150,000 records. Performing an update of 10,000 records using a SCD stage took 2 hours... I have to use it because I have a SCD stage which cannot be used with a load/tru...

ArndW wrote:That would not be a hex or binary viewer. The goal is to get the numeric representation of what is in that character. ...

Should I load the data into a dataset and open it afterwards ?

algfr wrote:So far not resolved yet, I'm still communicating with IBM, it's strange other people didn't have thsi problem that much.

Anyway I'll let you know

Ok, this is the correct patch, this works now.

Ok I did it, a few records cannot be inserted using TOAD loader tool. 1) Some records exceed the max limit (though i KNOW it can't be). I suspec some special chars to be badly transmitted (soem become question marks ??), thus extending the string. Can this be solved ? I tried changing the NLS set bu...

I've got it, it was my row skipped option in the data viewer. I'm so sorry ... javascript:emoticon(':oops:') Perhaps it gets filtered from the dropdown list. Try to use the table in job and see what your error message(if any) is. ... Hi ArndW, Well I filter the list using the SYSIBM library. I get t...

Perhaps it gets filtered from the dropdown list. Try to use the table in job and see what your error message(if any) is. ... Hi ArndW, Well I filter the list using the SYSIBM library. I get this error message, doesn't help much... ##I IIS-DSEE-TFCN-00001 11:09:52(000) <main_program> IBM WebSphere D...