Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 39 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 102 Oracle Analytics and AI Trainings
- 17 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
OBIA 7.9.6.4 - How to do a full load with less data
Hello,
I am trying a full load with a small subject area... I am using the $$INITIAL_EXTRACT_DATE parameter do load just the more recent data... Unfortunately I believe that the dimensions are not subject to that cutoff date... just the fact tables... due to the need of keys relationships.
One of the dimensions is very large and it is causing issues in the load...
Pls. is there any other way of limiting the load ?
Txs.
Antonio
Answers
-
Also check these
$$ANALYSIS_START
$$ANALYSIS_START_WID
0 -
please check the value of your $$LAST_EXTRACT_DATE also.
0 -
Txs... but according to na old DAC manual.. $$ANALYSIS_START is The start date used to build the day dimension and to flatten exchange rates and costs lists.
It seems that it does not affect the extract.
Antonio
Enviada em: sexta-feira, 12 de fevereiro de 2016 12:40
Para: Antonio Lomboglia
Assunto: Re: - OBIA 7.9.6.4 - How to do a full load with less data
<https://community.oracle.com>
OBIA 7.9.6.4 - How to do a full load with less data
created by Srini VEERAVALLI<https://community.oracle.com/people/Srini+VEERAVALLI> in Business Intelligence Applications - View the full discussion<https://community.oracle.com/message/13683211#13683211>
0