DSXchange

Hi Is there a possibility in DataStage PX to generate a surrogate key which is continuous for multiple runs also. For Example: If in 1 run, the surrogate key generator generates 1 through 10 keys, then in next run the key count should start from 11 and continue the count from there on. Thanks in Adv...

kumar_s wrote:Where you given the option? And how and where you triggering the job from? ...

Designer while running limit tab given option no limit

The jobs is getting aborted because of exeedwarning messages after giving no limit option also

dspxlearn, Thanks, but I have seen the link n thats not the problem as it works fine with a folder stage in server job. chulett, The XPath expressions and the XML that I am using are below. With a Folder Stage in Server Jobs its working fine but requirement is for a Parallel job. /defns:contracts/de...

yes, I have created the xpaths using XML Meta Data Importer itself. I am taking only three columns for my output out of the many columns. So checked the Xpaths too. All the three are in proper syntax. What else could be the problem?

I have tried the External source stage but that also is not solving the problem. Data(XML File name) is going from the External source to XML Input Stage but not going out of the XML Input stage into the Seq File. External_Source_0,0: Import complete; 1 records imported successfully, 0 rejected. Seq...

Hi, I am new to XML Stage. Getting the following error in the XML Input Stage while using sequential file to read the XML document. XML_Input_0,0: Error occurred in call to ORPHCallActivePluginInitialize(). In the source Sequential file I have given a single column. Also I am writing the data in a F...

I am getting this error when i am trying to run job with src file and tgt Oracle and inorcale stage if i used truncate and load are append load it is giving this error when i used upsert uits is working fine my err message main_program: Fatal Error: Caught ORCHESTRATE exception in main program: APT_...