Duplicating and referencing queries
Duplicating and referencing queries are somehow similar. We duplicate a query when we need to have all the transformation steps we already took on the original query. At the same time, we want to change those steps or add more transformation steps. In that case, we must change the original query’s nature, translating it so that it has a different meaning from a business point of view. But when we reference a query, we are referencing the final results of the query. Therefore, we do not get the transformation steps in the new query (the referencing query). Referencing a query is a common way to break down the transformation activities. This is the preferred way of preparing the data for most Extract, Transformation, and Load (ETL) experts and data warehousing professionals. In that sense, we can do the following:
- We have base queries connected to the source system that resembles the Extract part of the ETL process.
- We reference...
