DSXchange

Hi, I'm trying to parse an XML file using the XML_Input Stage, after I run the job, it gives me the error of "The schemaLocation attribute does not contain pairs of values. " If I remove all namespace declarations in the Starting tag and remove all those namespaces in the XPath in the outp...

I see the .odbc.ini which is used to define a datasource and being used in the ODBC Stage, but for a particular Stage like OracleConnectorPX Stage or Netezza Enterprise Stage, how can I use these stages to connect to that corresponding database.

Hi, I am trying to figure out how to set up a connection between the DataStage Server and a Database server. For example, I have an Oracle Db installed on a different server, if I want to use the OracleConnectorPX stage to connect to that DB server, what should I do to connect to that server. Thanks...

Hi, I have a previous project's job in which there's a lookup stage. Right now this LookUp stage doesn't match records eventhough there is a match between the source link and the lookup link, how could that happen? It's an urgent task for me to figure it out, can anyone help me on this issue? Thanks...

Hi, I installed the Information Server on a virtual Machine hosted by CentOS 5, now after I start the server and try to connect to it through the DS client, it gives me the following error javax.security.auth.login.LoginException: A communication failure occurred while attempting to obtain an initia...

Hi, I just want to confirm how the File Initial Value option in the stage properties is used. I know it is used to initialize a value to the key source, but if there is already a value in the keystate file, will the File Initial Value overwrite it, and no matter how many times the same stage will be...

Hi chulett I have two input Sequential file each have two columns and their datatypes are varchar.My requirement is the output file have four columns.First two columns are direct mapping from first input file and other two columns have to be loaded with data randomly picked from the two columns in t...

Hi all,


I have to pick up data from a column randomly.My column datatype is varchar.I am using datastage 8.1.How can I do this????

Thank you, Ray

Thanks, so in our project, I see in the scheduler, the sequence job S1 is called as S1.<some text>, and looks like the DSJobInvocationId will pick up the value of <some text>, I just want to know whether this is the only way we can assign our own value to DSJobInvocationId?

Hi,

I have a User Variable Activity Stage in a Sequence job, which is using the DSJobInvocationId. My question is how to pass a value to DSJobInvocationId when I run that Sequence job. For example, the Sequence job name is S1. Thank you.

Hi PaulVL
I checked APT file configuration of both projects.They looked identical.

Any other solutions

We have 2 projects in same server,one for development and another one for testing.One of the job using sequential file->XMLInput->Transformer->Dataset file Input sequential file has 40000 XMLs(size nearly 1 gb). Each XML is in a single line We imported this job in both projects (development & te...

Hi, Our company has two projects which are using the Surrogate Key Generator. There's a difference between these two projects' Surrogate Key Generator stage. One's properties only have "KEYS". The other has "KEY SOURCE" and "OPTIONS". Even though they have the same icon...

One of our sources sends us XMLs. I am facing an interesting issue how to parse multiple child nodes. How do we deal with multiple child nodes in XML stage, where the nodes are repeating. Since we don't know how many child nodes might appear, and all these nodes are identical , for e.g. if we consid...