Home » Fusion Middleware & Colab Suite » Business Intelligence » How to deal with deleted records in Data Warehouse
How to deal with deleted records in Data Warehouse [message #655327] Sun, 28 August 2016 23:15 Go to next message
azamkhan
Messages: 552
Registered: August 2005
Senior Member
Hi Guys,

I am using ODI for data transformation. New and updated data can be handled by the ODI tool but can any one please tell me how to deal with the deleted records.

I mean if the OLTP server has some changes lets say the EMP table has few records that are deleted. Then how can these records be also deleted from the OLAP server.

I am sure one should not has to compare the records of OLTP and OLAP servers manually?
Re: How to deal with deleted records in Data Warehouse [message #656237 is a reply to message #655327] Thu, 29 September 2016 05:31 Go to previous message
Flyby
Messages: 181
Registered: March 2011
Location: Belgium
Senior Member
If the source doesn't provide a list of deleted items, you could query the primary keys if they still exists in the source
Previous Topic: migrate obiee11g to 12c
Next Topic: Missing char when migration from obiee 11g to 12c
Goto Forum:
  


Current Time: Thu Dec 14 04:55:37 CST 2017

Total time taken to generate the page: 0.01697 seconds