DSXchange

Hi, While loading from one table to another table in ETL job, ETL uses temporary tablespace called PSTEMP and it is giving error "Unable to extend temp segment by 256 in tablespace PSTEMP". But we did not set explicitly anywhere in the job which tablespace it should use temporarily. Could you please...

Hi, I have a job which pulls the data from XML file and inserts into a table. While reading the data from the XML , in XML-In stage i am getting a record count of 200 (which is correct) . but only 5% of the rows are getting inserted in to table. I found that, couple of the elements in the XML file c...

I have a job which pulls the data from staging and inserts in to 4 target tables with SQL action "insert new or update existing rows". When I try to run the job , it never gone to success. Just all the links color chages to blue(processing) and that's it. I have only 3 rows in the staging. I am able...