175k views
0 votes
Give three reasons why you think ETL functions are mostchallenging in data warehouse environment.

User Nogood
by
6.3k points

1 Answer

7 votes

Answer:

Because of the nature of the source systems ETL functions are challenging.Reasons are as following:-

1. There are various source systems are very and contrasting.

2. There is usually a requirement to deal with source systems on different platforms or Operating Systems.

3. Quality of data is uncertain in many old source systems that have developed gradually over time.

User Joshua Kemmerer
by
6.8k points