InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Give an example of work flow in production? |
|
Answer» There is a fact table that you want to update and you have created a data flow with the transformation. Now If you want to move the data from source system, you have to check last modification for fact table so that you extract only rows that has been added after last update. In order to achieve this, you have to create one script which determines last update date and then pass this as input parameter to data flow. You also have to check if data connection to a particular fact table is active or not. If it is not active, you need to setup a catch block which automatically sends an email to administrator to notify about this problem. |
|