Data Warehouse [SSIS] Questions: Notes: What are Data Mapping Documents for? After the Data Warehouse or Datamart has been designed, to properly populate a data warehouse the source data has to be mapped correctly and accurately to the destination sources and facts. What are Data Dictionary Documents for? If the source data is not properly […]
Data Warehouse [SSIS] Questions: Notes: What is a Data Flow Task? A task which enables you to extract and transform data from various sources and load them to an array of destinations such as relational databases, flat files, and XML. The data flow task also allows you to apply several out of the box […]
What is report life cycle? The report life cycle is the sequence of activities associated with a report from creation to delivery. Reporting Services fully supports the three phases of the report life cycle, which include report development, management of the report server, and report access by users. What is report development? You develop reports […]
SSRS [General] Questions: Notes: What are the differences between Push and Pull Deliver Methods? With the Pull delivery method, the user is accessing the file from the Report Manager themselves. With the Push delivery method, the reports are automatically delivered to the user. What are Subscriptions? Subscriptions are a functionality with SSRS that pushes […]