Shall we understand that...

1- Your system is cumulative loading of a particular table.

2- Each day you get new rows that have to be inserted.

3- Each day you get updates to...

salliven (8/22/2012)

---

I don't know what database is runing the query...

imani_technology (8/21/2012)

---

I have to modify the design of a data mart I "inherited." Currently the big picture is this:

ETL Staging DB (EDI, Excel, and miscellaneous text files are loaded...

How about in your DIMENSION table?...

I understand the offending "report" is created by several storedprocs which means several queries. If this is the case you have to figure out which query (or queries) are the...

Okay - we already know it is not an Oracle issue and also that it is not a linked server issue; we know this 'cause you stated that you can...

I think you can include "dbid" column on profiler - it should tell you from where the query is being executed.

Development Environment, Test Environment, Production Environment?

It doesn't matter if stand alone or cluster - no confusion.

... environment?

newbieuser (8/21/2012)

---

Thanks for your replies.. we need to migrate 3-4 tables in Oracle to MSSQL and refresh the data on an ongoing basis.

There are about 50000 records in each...

Cross posting. Please reply here http://www.sqlservercentral.com/Forums/Topic1348134-1044-1.aspx

Please do not cross post.

...which means it is not an Oracle side issue.

This issue may be better addressed on an Excel...

Glad it worked...

Cross post, please answer here: http://www.sqlservercentral.com/Forums/Topic1347483-1044-1.aspx

Phunhog (8/20/2012)

---

Hello Oracle Forum:

I've got my first linked server established from SQL Server 2008 SSMS to Oracle.

What is the proper syntax for this simple query with a date expression in...