DSXchange

Hi, I have a requirement were i have to load data from a dataset to 4 diffrent oracle tables(Master,Detail) which have constraints that detail cannot be loaded until Master is loaded . This has to be achieved in a single datastage job as the data has to happen in a single commit after all the data h...

Thanks for the reply. I will discuss this with my dba.

Thanks for the reply. Do we set the commit row interval using the below 2 environment variables, in this case(I am not sure as this is not Upsert Load Method) $APT_ORAUPSERT_COMMIT_TIME_INTERVAL $APT_ORAUPSERT_COMMIT_ROW_INTERVAL please guide me ,how to set the commit intervals when I am using the L...

Hi, I am using Oracle Enterprise stage to Load table into a Oracle database using the below option Write Method : Load Write Mode :Append I am using the below environment variable $APT_ORACLE_LOAD_OPTIONS --> OPTIONS(DIRECT=FALSE,PARALLEL=TRUE) is there a way that i specify the Oracle to Commit all ...

I have tried the option where we pass XML from 1 XML stage to 2 XML stage etc.My job design is as below XML Input1--->XML Input2----->XML Input3------->XML Input 4-------->XML Input5----->XML Input6------->Sequential File In each of these XML stages I select a column as repetition element and then p...

Hi Ernie,

I tried out using a single XML stage with diffrent outputs and worked perfectly as desired.I will look into Kim Dukes best practices and try to merge the records.Thanks for pointing me in right direction.

Hi, I have a XML which has 8 hierarchy levels and each level has elements which are repeating. I achieved this by defining 8 XML Input stages (i.e one XML stage for each repeating group) and got the required output. But the problem I am facing is I have to tie back all these outputs together and loa...

4 nodes.

For example if I have 500 rows for which i would like to generate sequence starting from 1 to 500. the SGK stage generates sequences from 1-104 by incrementing with 1 but after 104 it jumps to 1001 and it increments in 1 until 1102 and again jumps to 2001.

Hi, I have a Job1,where I am using the Surrogate key generator(SGK) stage to generate a unique sequence .I am using the State files to generate a sequence.Below are the steps which i have followed to get this working 1.Created a JobA with just SGK stage to create the state file with no inputs and ou...

So I should have three more xml stages after i read from the first xml stage.Am I right?Can you explain me the below in little detail. You do each in its own link...and one repeating element as "key" for each link. I am totally new to the XML stage,so kindly help me out. Thanks in Advance.

Hi , My job design is as follows External Source Stage-----> Transformer-------->XML Input stage -------->sequential file. The problem is we are not able to read the data properly with a single key. When I download the metadata for the xml file,we have 5 columns which are specified as keys. Can some...

I just want to know if the new IIS v8.1 version has a datastage version control or not.

Thanks in advance

Thanks for the inputs mekrreddy, I will keep posting as and when we encounter any issues if you can help us resolve the problem.

Thanks again for your help.

Thanks for the expert opinion.