BI 7 Flashcards
What are the five new resources
Model, Data Source, Solution, Pipeline and Model Server
What are the three sub resources of the model
Data Source, Solution, Pipeline
How is the data migrated from the data source to the DW, and why?
ELT. Saves load on the source system.
What does the model server do?
stores credentials for dw and cube, works as a cube server for analytics
What is the first step in the pipeline architecture?
Making a copy of the source data in the staging environment
When naming pipelines, what is a best practice?
Don’t change the physical name of a pipeline, as it will break existing reports.
For Reporting
Similar to for denormalization only.
What is a best practice for filtering?
Filter at the data source level if possible, to reduce disk space
What is the best practice for naming warehouse sql pipeline?
Drag and drop from resource explorer, or add a $ prefix and suffix, or just type a $ and you will get intellisense
How is the Zap_Timestamp handled in a sql pipeline
Preserve case (capitalization)
How does one materialize a warehouse table for later use in ELT process?
Split the pipeline. If you are doing an aggregate, for example, you would have your first pipeline end at the aggregate step. Then create a new pipeline that refers to the previous pipeline.
Explain source vs. warehouse incremental
Source - source to staging
Warehouse - staging to warehouse table
Create Warehouse table checkbox does what?
You can choose whether or not to materialize a warehouse table from the pipeline by checking or unchecking this setting
Syncronize deletes checks for deleted in the source (T/F)
False - Synchronize deletes refers back to the staging table, this prevents overloading the source with what could be a computationally heavy comparison query
