Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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