| |
GeekInterview.com > Interview Questions > Data Warehousing > ETL
| Print | |
Question: In what scenario ETL coding is preferred than Database level SQL,PL/SQL coding?
|
| December 12, 2008 05:04:40 |
#3 |
| sri_test |
Member Since: December 2008 Total Comments: 3 |
RE: In what scenario ETL coding is preferred than Database level SQL,PL/SQL coding?
|
| Usually Warehouse is preferred in banking,insurance,health care domains. In these environments especially in banks output is provided by business person in excel,notepad,word,Access format. Suppose if the user wants to draw a survey or graph using all these information then we normally go for reports,to generate these reports source data must be in sync (or single source), so we use warehouse to convert all these sources to single source system using ETL code. |
| |
Back To Question | |
