State the differences between shortcut and reusable transformation - ETL
ETL (extract, transform, and load) Testing Interview Questions
(Continued from previous question...)
20.State the differences between shortcut and reusable transformation - ETL
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.
(Continued on next question...)
Other Interview Questions
|