DSXchange

Thanks for your Quick response, Actually we ran the same job today early morning as nothing is running any thing on the database.Still we are getting same problem. We have checked with the DBA's they said that they dont find any problem in that database. Actually we are facing that problem while loa...

Nature of the Table:The table has one primary key constraint and one foreign key.It do has some indexes.
Nature of Load: Insert ( Direct Insert - No Validations)
Hardware:Both ETL and Oracle are on different Servers(Unix AIX).

Thanks
Vas

Hi, We have a Parellel job which insert data from Dataset to Oracle database using OracleEnterprise stage. Till last week we have seen very good performance(nearly 3000 rows/sec). But now it is loading at the rate of 400 rows/sec. Even we have did some performance testing on Database server.Every th...

Hi,
I guess u can use longvarchar which accomidates for 10000 bytes.
But 30000 bytes is a too big to handle.

premalekya@yahoo.com

Thanks in advance
Vasu

I Have a Sequential File which has the Data in the fallowing Format. Header1 detail--- detail--- Trailer1; Header2 detail--- detail--- Trailer2; Header3 detail--- detail--- Traile3; For every header it contains a Unique Product no. So i need to Generate a sequential file for Each Product NUmber. How...

HI
We are using Parallel Job for Loading Some data in to Oracle Tables .
Lets say there are total 100 rows to load in to the Table ,for some reason It has loaded only 50 rows and how can we Rollback these rows from datastage as it is Half done.

just use the modify stage instead of transformer stage.I even came across the same problem .
vasu

hi all i am having a sequential file and it contains header and body.the header should go in one table and body should go in another table.but the problem is that while inserting in to the tables i have to create a new column in both the tables which contains a number and should be in sequence when ...

hi i want to know how to generate a surrogate key based on two columns
in datastage 7.0 presently ,we are using datastage 7.0 and i heard that there is a new surrogate stage in version 7.1.
please help me in this problem
vasu[/code][/b]