OBIA 11G: Can You do a Truncate and Load For a Particular Fact or Dimension Table?
Last updated on JANUARY 31, 2017
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124.1 and later
Information in this document applies to any platform.
- You have scenarios in which you had to reload a particular fact/dimension table because a new column was added or something else changed. Is there a way to do this other than deleting the records from w_etl_load_dates? If you delete the records from w_etl_load_dates you might miss the flow to load the table again.
- It is possible to create a new load plan for a fact group. If you can create a new load plan for a particular fact group will it do a full load of the tables associated with it?
For example: If you are adding a new column to a table and want to load the column do you have to do a full load for the table? How can you do that by creating a load plan for a particular fact group?
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 hundreds of Community platforms