Current PSA Record View

Design patterns greatly speed development.  The DP3000 & DP3100 design patterns create a data flow which tracks the current version of records in PSA based on a selected key field.  The result is a new field in PSA called isCurrent by default which identifies the current PSA record with a value equal to 1.

At times it is useful to query PSA directly, and in this case the current version of PSA records is often the desired view.  However, PSA is not a table that is typically made available to end users.  To resolve this, the above mentioned design patterns can now optionally create a view which presents only the current version of PSA records.  The view that is generated simply selects from PSA where isCurrent = 1.

After generating a data flow using DP3000 or DP3100 with the option to create a current view component, you will end up with a data flow such as the following.  Note that this data flow also includes components required to load a dimension.

Enjoy!