My Oracle Support Banner

How to Filter a Datasource and Move the History to a New Datasource (Doc ID 2639147.1)

Last updated on DECEMBER 23, 2021

Applies to:

Primavera Data Warehouse - Version 16.1.0.0 and later
Information in this document applies to any platform.

Goal

How to filter an existing ETL and retain the history data while moving this to a new datasource.

For example, using filtering to split a single datasource (datasource_id=1) into two separate ETL runs - i.e. datasource 1 and datasource 2; when history is captured, this would currently all be assigned to datasource 1. This document describes the process to retain the history and update the proper history rows to datasource 2.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.