DSXchange

I am developing a new job to an existing target table. I decided to initialize the seq with max+1 value to skey file and do an update/insert into the table, so created job to load the data to the target table, whenver there is no lookup found i generate the SKey from the utility, data is generated c...

I tried executing the qualitystage job from the back end on Unix Server Since we dont have GUI/Client for qualitystage, it works fine. But it looks like its all scripts which is called....can i copy these scripts and dependency objects into a new Unix Env and execute the same script? my point here i...

Looks like the reports might not reveal the mapping rules of the job.......! need some workaround....! please advice...!

Have a requirement to generate a report for a qualitystage job.
Because of the liscensing issue, not able to view the jobs directly, would like workaround this issue by generating a report about these jobs and find more information about the job. Please advice.

Can we have a seperate forum which only focusses on RealTime Data Integration using DataStage Webservice using DataStage tool? these topics get lost in the DataStage Enterprise edition forum......and since that forum more focusses on individual stages..than the Webservices Pack and XML.

Hi Folks, Requirement: Load the DB table in MDM EBX(This Database is a propietary database format), only way to load this Table would be to call Webservice they provide. Here is the approach i am planning to take: Oracle------>TFM---->XML FILE---->WebServices Client PS: Webservices WSDL when importe...

You have multiple xml, use three stages and funnel it later in your job OR
Load this in each run by calling the same job 3 times or by looping via multi instance method.

what is you requirement, why you want to do this way ?

No webservice runs just fine. Okay the xpath description doesnt have double underscores which is correct. Checked both in IN and OUT table defs, both of them have column metadata filled with double undescroes but their description doesnt have double underscores. The Job runs fine since the xpath is ...

Thanks for the information.

Tried importing table definiton from oracle db using plug in metadata definitoon and orchestrate definition in datastage version 9.1. When i load the metadata in the oracle connector target stage column size is increasing from 255 to 600 , has any body faced the same situation? I literally have more...

i am having more than 200 columns and this is version 9.1. has any body faced a similar situation?

Trying to import metadata definition from the WSDL document, all the column names are changing from col_name to col__name, not sure why i am getting two underscores in place of single underscore.

technically it doesn't matter, but i wanted to create table in a systematic structure, my question is why the connector is not following what order i gave in the target oracle connector stage ?

Column metadata is created in orderly fashion in oracle connector stage, The DDL statement is not following that order.