State the differences between shortcut and reusable transformation - ETL
State the differences between shortcut and reusable transformation.
Shortcut Transformation:
- A reference to an object that is available in a shared folder
- These references are commonly used for various sources and targets which are to be shared between different projects or environments.
- In the Repository Manager a short cut is created by assigning ‘ Shared ‘ status.
- Later objects can be dragged from this folder to another folder.
- This process allows a ‘ single point of control ‘ for the object and multiple project do not have all import sources and targets into their local folders
- The Ids of customers would be useful to load customer details from several source systems and allocate a set of unique ids to every new source-key
Reusable Transformation:
- It is local to a folder. Ex:- reusable sequence generator for allocating warehouse Customer ids.
- It is useful to load customer details from multiple source systems and allocating unique ids to each of new source-key.