Data Warehouse [SSIS] Questions: Notes: Can you create a Differential Backup with an existing Full Backup? You use a differential backup along with a full backup. If a full backup does not exist, you cannot create a Differential Backup. As with a full backup, you can perform a differential backup of a database no […]
Data Warehouse [SSIS] Questions: Notes: What are the types of Control Flow Elements? There are 3 different types of control flow elements in SSIS. There are containers, tasks, and precedence constraints. These all have different uses in the control flow. What are Containers? Containers are used to give structure to packages. There are 3 container […]
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 […]