DSXchange

First, please do a better job with your choice of subjects, they should represent the nature of the question or problem you have. Something generic like 'Hi' or 'IBM Information Server' makes searching difficult. Secondly, do you have the MKSToolkit installed on your DataStage server? I'm curious if...

Couldn't you just divide it by 100?

You affect the number of node pools at the job level by using different config files. Create a new config with fewer nodes and use $APT_CONFIG_FILE in your job to override the default config assignment.

Any chance there is a Pivot stage involved?

viewtopic.php?t=127535

Because you are doing the substring in the query, DS has no idea and so looks at the metadata and issues the 'possible truncation' warning. You should be able to select the entire field and then do the substring in the derivation downstream to avoid that message. I do believe.

That would be a question to an Analyst or Modeler at your site, not sure how anyone else would know your data / structures.

pattemk - I have no idea what you just tried to post as for one I can't find any new content in it. Never mind that you cannot check the "Disable BBCode in this post" option and then expect the tags to work.

Jeez, don't people use the 'Preview' button at all?

mandyli wrote:But I am trying to get active user list from xmeta table.

We know, we know. This is like what, your third post on the subject?

Absolutely. Make sure you spread the love right back and post whatever it is you find out. Not sure that sounded right, but you get my drift...

What Query Type have you selected? You have three basic choices (four if you count 'load from a file at runtime') and all can do what you need. 1) Use SQL Builder Tool. Something I wouldn't touch with a 39 and a half foot pole, but it uses an 'Access style' interface to build the query for you. Yuck...

If I had to guess (and I do) I would think the answer is 'yes' but you'd really need to raise the issue with IBM to know for certain.

Try an exact search for "Unknown Name" without the quotes.

I thought I would also add an example of the same data being processed when the only change is to make the Array Size 10. Otherwise, all else is the same as the first example posted above, including the Transaction Size of 0 and a Warning Limit of 3: TestOCICommit..TEST_OCI: OCIInitialize - Initiali...

i have task in which source needs to access multiple dimmension tables and i dont see oracle oci stage have capibilty to access multiple tables from source. :? Of course it does, just like any other DB stage. What exactly do you mean by that - you need to join multiple tables? Create separate sourc...

What database are we talking about here? DB2? Knowing that can help determine what your options are.