LeapFrogBI enables the use of existing tables and views. For example; when extending an data mart there will be existing dimensions that need to be referenced by the new fact table. In this case we need to profile the existing
Monthly Archives: May 2012
When creating a PSA component, the designer is asked to assign a value to RecordDateTime. The selected value will have implications downstream on both fact and dimension components.
RecordDateTime is the point in time which the record is
When a fact component attempts to load a record, a foreign key to a dimension lookup is performed. This lookup (join) may fail if the dimension does not have a record that meets the fk join definition. In this case
When using a merge statement to load a fact table it is important to ensure that the source component/s do not contain more than one record with the same composite foreign key. Often this can be resolved by performing an