DSXchange

Can you check if the nullable option is set the same for the input and the output.

Hi,

Can someone help me in explaining what this following warning stands for

LoadROLine..OcROLine.SLROLineInsert: DSP.Close Error -2 in $DSP.Close.

My job also throwing n number of constraint key violations while trying to insert to oracle table. Is the above warning some way realted to this.

Hi,

Is there a way to conditional parse an xml based on the value in a specific tag. If the tag value is say "x" i want to reject the xml without doing further processing.

Thanks in advance

I thought of two ways

(*) Having the update records to be in a sequential file and then do the update operation afterwards
(*) cHAGNE THE ARRAY SIZE AND THE ROW TRANSACTION TO 1 IN THE ORACLE STAGE.

Will this solve the probelm.

Thanks in advance

ketfos wrote:Hi,
You already ahve the answer to the problem.
How are having the same link table for reading and simultaneous updates?


Ketfos

But evenif I do that the record will first do a lookup and then go for the insert/update right. Am I missing out something..

Hi, Another issue. Job design is as follows HashFile --> Transformer --- > INSERT/UPDATE TO TABLE | | Lookup Table Lookup table is the same table that i am inserting and updating to.. Will this work ... In the log i can see oracle deadlock messages can it be due to simulatneous read/write by this jo...

Hi, Recently I am having issues with a job with fetches info from a hashfile and do an update/insert to a table. The job on the first run compelets succesfulluy. But when I view the monitor the status of one of the stage is showing up as Other = 0.To add to this , the job should process alteast 2000...

Hi, I have job which start with a pretty good rows/sec of around 120. But as the job runs the rows/sec goes on decreasing to 10-15.Job used to take around 2-4 hours but on certain days it went on for 6-8 hours. I checked with my DBA for any locks . But as per the DBA everything looks ok. Job reads f...

Pavan, the same can be achieved by using a sort stage and a stage variable in the transformer

Thanks Kenneth. In the second scenario, The lookup hashfile I am using is having mutlikey. One of the key columns is having a null value and this key column happens to be the one checked for null in the transfomer constraint. So is there a chance that this particular record can pass through eventhou...

Job design is like this Folder--> XML Parser --> Hashfile1 ---> Transfomer---> Hashfile2. I have defined the Hashfile2 with 3 keys and one of the keys is formulated as the concatenation of 10 fields. The issue that i am facing is whenever a xml tag is missing or if the value for a tag is null, the k...

Any constraints in using Oracle Bulk loader

But if the source data contains a row which got loaded to Table B by lletz say a previous days load.. Then I doubt if with the above logic "For every unique row in table B, I have to generate a sequence number which I have to enter in Table A." this requirement will me met or not. I am sor...

In a job I look-up a hashfile to get the values from the oracle table. The database link is a reference link. The reference query is like select col1,col2,col3,col4,sum(col6) from tab1, (select col1,col2,col4,max(col3) tempcol from tab1 where substr(trim(string(col3)),1,7) = ? and col4 = ? group by ...

Thanks for the inputs. How can we explain the link refresh rate of 500 when this link causes the job to run for more than 1 hr. DataStage Server and Oracle Server resides in different m/c . Is the communication drop between the m/c has to do something with the job. If the communication drop happens ...