DSXchange

I need to do around 200 lookup to get descriptions for every code for every rows. Doing 200 Lookup is ugly design. same is needed for multiple tables.


Input rows are around 10Mill Records. Tried Parallel routine, but its slowing down.


Can some one suggest me what need to be done.

You can only export the executable, datastage gives this options. Try to select option "Export Jobs without Design" .

My job was working fine till 2 days back. There was upgrade in the AS400 box and we started getting errors. Our errors are mostly related to while reading data and if column has # in the name. We get error if we read data Select M5HOSP, "M5PAT#" as M5PATNO From <> But if we replace sql lik...

I belive Web service client and transformer are working with WSDL. They does not support URL call.

Please let me know in case i am wrong .

Regards,
Krishna

Have you got solution for this issue

I have to get Latitude and Longitude

By calling Google API URL

http://maps.googleapis.com/maps/api/geo ... nsor=false

From data stage, what stage can be used for this. Please help me.

Thanks in advance.

Regards,
Krishna

Hi Experts,

Is possible to change the default file path for dataset parameters.
Please let me know where to change that.

Regards,
Krishna

Does any one have patch no for this fix Ok....then you should be ok, but there may be some fix/patch issues to consider (again...suggest that you search thru the forum here and also call your support provider). Also --- try it in a Server Job to see if there are any differences...there were situatio...

Is it possible to call a server a routine from another server routine.

What is syntax.

It is what it is, seven "instances" of a thing called EObj... You need a technique to "reverse pivot" your seven rows. I'm sure there are many such techniques described in the forum here (it can be done in a variety of ways that use everything from stage variables to Aggregation...

Ok....then you should be ok, but there may be some fix/patch issues to consider (again...suggest that you search thru the forum here and also call your support provider). Also --- try it in a Server Job to see if there are any differences...there were situations in the past where it worked in one j...

"could" be a support issue..there were numerous issues with validation. Check with your support provider....and search thru here -- the subject has come up before. Someone else may have confirmed various symptoms as having patches. In the meantime, what kinds of invalid are you looking fo...

Hi, I am trying to Validate a XML file with the XSD through XMLINPUT Stage. Mentioned the path of the XSD file in the XML file, Given the reject link to capture the error message, Mentioned as 'reject' for all types of validation errors, Still I am unable to capture the error in reject , Job is gett...

No. (I assume you mean "simultaneously".) The operating system imposes a limit of 1 on the number of writers to a file, and the data in Data Sets are stored in operating system files on the resource ... I am able to write one same file from multiple jobs , running at same time. Is there a...