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: 557
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?

Report message to a moderator

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: 188
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

Report message to a moderator

Previous Topic: migrate obiee11g to 12c
Next Topic: Missing char when migration from obiee 11g to 12c
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 04 17:24:46 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.