Using ETL also means you won’t be able to access your raw data in your warehouse. Between setting up your transformation process, ongoing maintenance, and the waiting period while your data is transformed and prepared for loading, it can make accessing your data a lengthy (and costly) process. Cons: One of the downsides of ETL is that it’s far more time consuming than ELT. Additionally, you can build data security into your ETL process by ensuring your transformation protocols account for any encryption or masking is needed for the data regulations your organization needs or wants to meet. So for limited storage capacities, it can be beneficial.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |