You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BICC Union all - documentation

edited Apr 15, 2024 1:23PM in BI Publisher Learning Center 1 comment

Summary:

Does someone have any experience or documentation on implementing using UNION all in BICC on incremental extracts?


Content (please ensure you mask any confidential information):

In following Oracle documentation is mentioned to use Union All for incremental extracts

https://docs.oracle.com/en/cloud/saas/applications-common/24a/biacc/creating-a-business-intelligence-cloud-extract.pdf


There is very little documentation on what this exactly does or what the benefits are.

So we are wondering if there is any reason why 'Union All' should be used instead of 'OR' for incremental extracts in BICC.

Version (include the version you are using, if applicable):

24A

Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!