DSXchange

Thus the only reason I can think of why my composite query here is crashing (especially since the message is ORA-14501: object is not partitioned) is IMO because one of my tables is not partitioned. That would certainly seem to be the case. Perhaps it would be worth putting in front of your officia...

Thanks Craig but I am confused since I've seen others getting a tongue bashing for not using the search function :shock: OK... we ask people to use the Search function to see if their question has already been answered as most questions are not new ones and they've already been asked and answered h...

BASU wrote:Not opening a new thread since quite a few exist on this

Sorry, that's not how it works here. You have a problem, you start a new post, doesn't matter if there are other sorta similar problems out there already... which will almost always be the case.

Welcome to your own post.

Let's start by getting your post in the correct forum.

(moved)

I'm sorry... you are using this "record count > 1" where? :? If I give record count as 1 its running fine with odbc connector stage but if give from 2 it is loading partial data... Which doesn't come close to answering my question, so decided to check the ODBC Connector documentation. It'...

I'm sorry... you are using this "record count > 1" where?

In output dataset i got the last two records, but i didn't go the remaining records in reject link. That would be because they were never sent to the stage due to your filter condition so they were not available to be rejected. As noted, the reject link handles metadata mismatches, records that cou...

Please stick to your own topic for discussion of this issue rather than fishing around for related posts made by others.

No need to repeat what is here in other posts. Also, marking this post as having a 'workaround' is probably keeping people from visiting it again...

No, not really. Seems like something you should be taking to your official support provider.

You're not the first to see this problem or to post about it here and yes you need to remove the last delimiter from the delimited list. Not sure how EReplace or Convert would be helpful, I seem to recall using substring to accomplish this - basically:

DelimitedList[1,length(DelimitedList) - 1]

It's a Server job, you do everything in the Transformer stage. And it is simple enough to setup the stage variables needed for this, or as you noted there are some interesting routines in the SDK that can be leveraged as well.

Transformer stage variables.

Is there anyway that by all default OCI stages dragged to a job canvas from palette can have 1000 as the Arraysize ? No. And there is no "one size fits all" value for the Array Size property. I suppose if you want to attempt to have a default of other than one for it you could try the tem...

Try adding the domain option. You may also need to specify the port, from what I recall.