DSXchange

initially we have OCI stage, with this stage we will connect up to particular databases, for example older datastage versions can not connect to oracle 10g, because at that time that verison of oracle is not developed, so with OCI stage we can connect up to some versions of databases based on the d...

shalini11 wrote:Sorry, I am not able to view your full answer.

Some premium content button is displayed. Could tou pls tell how can I view your answer

By purchasing a Premium Membership:

premium_membership.php

The Aggregator cannot support that number of unsorted records. For this to work, you'll need to presort the records in a manner that supports the grouping being done and then assert that sort order in the stage.

Write caching and 32 v 64 bit have nothing to do with this. The default cache size is 256MB, which is why what you have won't fit. You can increase the default in the Administrator but unless you understand all of the consequences, do so at your own risk, it can have some rather interesting results....

Hmmm... something similar was posted 5 years ago but it got no responses, other than that there's no mention of "UVRelVar" here.

Wait... sorry, should have noticed you are on a Windows server so won't have access to UNIX commands like "ls" unless you also have EE installed and thus the MKS Toolkit, or something equivalent. Do you? :? So for pure DOS solution, the /B option means a "bare" listing, i.e. just...

Mike wrote:Possible solution, use a single DRS target stage with 3 input links from the transformer. This should result in one database connection instead of three, thus eliminating the deadlock.

What Mike said... minus the "possible" part.

sureshreddy2009 wrote:First note down,variable is project level or job level

vijay.barani wrote:I have no user-defined query neither any variables defined !! (emphasis mine)

I have no user-defined query neither any variables defined !! All of the advice noted above still applies. The number and order of columns defined in the stage must match the number and order of columns selected in the query and every column bound into the 'where' clause must be marked as a Key. Pe...

Not having those instructions, no I cannot. However, your official support provider certainly can.

From memory - make a copy of the routine mentioned and then change the Open statement to OpenPath. No need for the VOC entry then, simply pass in the full path to the hashed file rather than just the name.

He's listed on the Contacts tab.

Just want to make sure that you know you can have multiple 'Version Control repositories' (projects) at any given time and "VERSION" is only the default - you're not restricted to that name. Yes?

I don't believe so, I only remember that as needed for Compaq Tru64. Regardless, the installation instructions should note that if it was step was necessary, no mention = not needed.

You have the MKS Toolkit installed, so UNIX commands should work for you... including "ls". Or some form of "dir" should as well, probably with the /b for "bare listing" option.