...I'm still not sure we are talking about the same things...
The ETL transfers the raw data to the MART, at pre-defined intervals. This is defined in the parameters for the ETL (Runtime) in CME (and also within the Java Properties files). They look something like this;
ETL Runtime: ETL_Trans_Only>Command>java -Xmx2048m -jar transform.jar -conf etl.properties
ETL Runtime: ETL_Trans_Only>StartTime>0:00+0:01
So, the data is transferred from the ODS to the Datamart, regularly.
When it has arrived, Aggregation takes place (based on the Time Profile???). Again, our ETL Runtime has parameters for this;
ETL Runtime: ETL_Agg_Only>Command>Java -Xmx2048m -jar transform.jar -conf etl.properties -aggOnly -
ETL Runtime: ETL_Agg_Only>StartTime>0:11+0:30
- So far, all of this has been about how the data is transferred and aggregated to the Datamart. Now, when I look at a NOAGG Table in the Datamart, my Time Keys are like this:
For a Layout which is set to the Time Profile "30 mins":
200908271100BST
200908271130BST
200908271200BST
For a Layout which is set to the "Default" Time Profile:
200908271115BST
200908271130BST
200908271145BST
200908271200BST
Returning to my question... It seems to me that NOAGG in the Datamart is defined by the Time Profile set in the DMA Layout and it should not, therefore, be assumed to be 15 mins - because it may not be....
I hope that is clearer?
T