If you are unable to create a new account, please email support@bspsoftware.com


I handle late arriving information in Facts

Started by Srik, 17 Oct 2005 10:04:34 AM

Previous topic - Next topic


Can any one tell me how to handle Late arriving Information in fact builds in Decision Stream.

Thank you in advance.



DecisionStream is already geared up to handle late-arriving facts - you just need to observe the following rules to be able to implement this functionality:
1. Your fact build must validate against lookups.
2. The lookups must read in data using Template Access rather than Datastream Access.
3. The lookups should bring in the business key, surrogate key and Effective Start Date from the dimension table as attributes.
4. Your fact build should not merge rows on input.
5. You fact build should not deliver dimensions.

If you make sure you adhere to all these rules, you will be able to go into the properties of your dimensional elements in the Transformation Model and turn on Late Arriving Fact Processing on the Late Arriving Facts tab.

Best regards,