Data Warehouse [SSIS] Questions: Notes: What are Merge Join Transformations? The Merge Join transformation will give an output by taking two inputs and performing an INNER, LEFT, or FULL OUTER JOIN on the two tables. The input data must be sorted according to the matching columns for this to work correctly. We can then derive […]
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 […]
