What is an OLTP database? OLTP-(On-line Transaction Processing) is characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE).The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and an effectiveness measured by number of transactions per second. In OLTP database there is detailed […]
What is an event handler? It is a workflow that responds programmatically to events that occur on a package level, container level, task level or change of variable value What is MSDTC? The built-in transaction support in SSIS makes use of the Distributed Transaction Coordinator (MSDTC) service which must be running for the transaction to […]
What is the difference between Fuzzy Lookup and Fuzzy Grouping? Fuzzy Lookup is used to find clean data. Fuzzy Grouping is used to remove duplicate data. Fuzzy Lookup works on a row by row basis. Fuzzy Grouping works on rows within a group. Fuzzy Lookup uses a clean reference source as well as its input. […]
Data Warehouse [SSIS] Questions: Notes: What are Asynchronous Components? The output of an asynchronous component uses a new buffer. It’s not possible to reuse the input buffer because an asynchronous component can have more or less output records than input records. The only thing you need to remember is that synchronous components reuse buffers […]