Data Warehouse [SSIS] Questions: Notes: What are Character Map Transformations? The Character Map transformation applies string functions, such as conversion from lowercase to upper case to character data. This transformation operates only on column data with a string data type. The Character Map transformation can convert column data in place or add a column to […]
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 […]