Dimension lookup/update

Application:Data Warehouse
Published By:AutomationEdge
The Dimension Lookup/Update bot can implement Ralph Kimball’s slowly changing dimension for both types: Type I (update) and Type II (insert) together with some additional functions. Not only can you use this step to update a dimension table, it may also be used to look up values in a dimension.