DSXchange

I have 43 gig file to be loaded to a table in SQL server 2005. There are about 2 billion records in there. Its a one-one mapping with no transformation. There are no keys on the table. Using DSR and ODBC Stages the performace on it was very poor. The maximum that DS could do was around 2000 - 3000 r...

chulett wrote:Stored Procedure stage. ...

thanks.

Will try it out!

lstsaur wrote:Sonia,
Actually the error from your Oracel Enterprise Stage is saying:
esql complaint: ORA-00900: invalid SQL statement.

Just use the STP stage that will save you a lot of pain.

Sorry for being ignorant, but what is the STP stage?

Thanks all. All the replies and few earlier posts from the forum were helpful to get the issue resolved. I used call instead of exec . after which there were a bunch of other ora errors ORA-01861 Error - parameter of date type was not passed appropriately to the package ORA-01008: not all variables ...

No, please try a third party application not Oracle's sqlplus. That is the whole point. Please use some third party application like Toad etc and test it. oops! ok , I will check this out. Thanks Correct me if I am worng Test 1 : Using PL SQL developer on my client I ran the package sucessfully Tes...

sud wrote:No, please try a third party application not Oracle's sqlplus. That is the whole point. Please use some third party application like Toad etc and test it.

oops! ok , I will check this out.

Thanks

If you do a search on ORA-900 error at google university, you will probably find that - and do check this - that this means that the Procedural Option is not installed on the Oracle instance. Before anything, try executing the same procedure from any third party application like Toad, PL/SQL develo...

Hi, I need to run an oracle procedure from DS parallel job. I am using an oracle enterprise stage and I say exec schema.package.procedure('val1', 'val2','val3','val4','val5') It throws a ORA - 900 error. I did check the same procedure from PLSQL, from the UNIX box and it did work. Any idea as to why...

If you convert the data type with a Modify stage you don't need SQL and can use Write write mode. ... Thanks Ray. Here is what we tried a. DBA created a new QA enviroment with more space and indepedant from other apps b. Tables created without index (foreign and primary key constraints) c. ETL jobs...

If you convert the data type with a Modify stage you don't need SQL and can use Write write mode. ... Thanks Ray. Here is what we tried a. DBA created a new QA enviroment with more space and indepedant from other apps b. Tables created without index (foreign and primary key constraints) c. ETL jobs...

I don't have access to enterprise edition at the moment. Does the ODBC Enterprise stage have another write mode? Something like "Write" or "Direct"? Please start a separate thread for the merge f ... Yes, there is a write method - "WRITE" with Write Modes - Append, Cre...

What stage type are you using? If an Enterprise stage, what write mode are you using? Have you considered writing to a text file (or an FTP stage) and loading the SQL Server table using the bulk loa ... ODBC Enterprice Write Method = Upsert Upsert Mode = Insert only I did think about bulk load, but...

Hi, On a daily basis 20 million needs to updated/ inserted into a table in SQL server 2005 database. These tables have foreign key references too. I do a delete and then insert. I have set the APT_RDBMS_COMMIT_ROWS to 10,000. I have user defined SQL statement. But it takes 5 hours to complete the lo...

Hi, Per my requirement I need to generate and XML file in the following format. As you can see TAG1 and TAG2 are non-repeating and TAG3 is repeating. <TAG1> <TAG2></TAG2> <TAG3></TAG3> <TAG3></TAG3> <TAG3></TAG3> <TAG3></TAG3> </TAG1> In my XML output stage I mapped as follows Column1 : /tag/tag1 Co...

chulett wrote:And who would you be?

I am sorry. Its the same me.

Thanks once again