Duplicating and referencing queries
Duplicating and referencing a query 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 some 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 in a more organized way. This is the preferred way of doing data preparation for most Extract, Transformation, and Load (ETL) experts and data warehousing professionals. In that sense, we can do the following:
- We can have base queries that are connected to the source system that resemble the Extract...
