![]() Compliance serve as the other advantage of ETL. After data transforming/structuring, efficient, speedier and stable analysis is allowed by ETL. OLAP data warehouse’s pre-structured nature serves to be the biggest advantage of ETL. Small or moderate data volumes are there.Compute intensive transformations are there.The target and source database are different and varied forms of data are used by them.Following are the cases in which ETL is use: The heavy lifting bulk, that is, the transforming part is conducted by ETL software when ETL is performed by user. After transformation of data is done, its loading takes place in target database that is data warehouse. For data transformation, the actions performed include applying calculations and or altering the data types. When the data is extracted from disparate sources and then it is transformed, the process is termed as ETL (extract, transform, and load). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |