Home » Developer & Programmer » Data Integration » New to Data Warehousing
New to Data Warehousing [message #147656] Fri, 18 November 2005 17:22 Go to next message
mayfield
Messages: 1
Registered: November 2005
Junior Member
Hello,

I'm new to data warehousing and need a query that will compare the data in one schema to the data in another schema. Example, transactionid, fee,provider_name in schema1 (tablename transactions) with the same fields in schema2 (tablename is Service). This query should also check for any duplicate data between the two schemas.

Thank you,
Mayfield
Re: New to Data Warehousing [message #147988 is a reply to message #147656] Tue, 22 November 2005 02:08 Go to previous messageGo to next message
ashwin_tampa
Messages: 40
Registered: October 2005
Member

i dont know any short-cut, but i've made
a sample for u , may be that can help u.

check the attached file.
Re: New to Data Warehousing [message #147999 is a reply to message #147656] Tue, 22 November 2005 02:36 Go to previous message
ashwin_tampa
Messages: 40
Registered: October 2005
Member

please ignor the ealier reply

there is small change in attachment.
Previous Topic: problems with the target configuration in owb 9.0.2
Next Topic: Informatica
Goto Forum:
  


Current Time: Fri Mar 29 11:02:36 CDT 2024