What is a data flow?

A data flow consists of the sources and destinations that extract and load data, the transformations that modify and extend data, and the paths that link sources, transformations, and destinations The Data Flow task is the executable within the SSIS package that creates, orders, and...
Read More »

What are the Transformations available in SSIS?

AGGREGATEĀ  – It applies aggregate functions to Record Sets to produce new output records from aggregated values. AUDITĀ  – Adds Package and Task level Metadata – such as Machine Name, Execution Instance, Package Name, Package ID, etc.. CHARACTER MAP – Performs SQL Server level makes...
Read More »

What is a RAGGED hierarchy?

Under normal circumstances, each level in a hierarchy in Microsoft SQL Server 2005 Analysis Services (SSAS) has the same number of members above it as any other member at the same level. In a ragged hierarchy, the logical parent member of at least one member...
Read More »

What is ROLAP?

ROLAP – Relational OLAP.Designates one or several star schemas stored in relational databases. This technology permits multidimensional analysis with data stored in relational databases.Used for large departments or groups because it supports large amounts of data and users. Read 63 Top MSBI interview questions and...
Read More »

Explain the TWO-Tier Architecture of SSAS?

?    SSAS uses both server and client components to supply OLAP and data mining functionality BI Applications.?    The server component is implemented as a Microsoft Windows service. Each instance of Analysis Services implemented as a separate instance of the Windows service.?    Clients communicate with Analysis...
Read More »

What is WriteBack? What are the pre-conditions?

The Enable/Disable Writeback dialog box enables or disables writeback for a measure group in a cube. Enabling writeback on a measure group defines a writeback partition and creates a writeback table for that measure group. Disabling writeback on a measure group removes the writeback partition...
Read More »

How to log SSIS Executions?

SSIS includes logging features that write log entries when run-time events occur and can also write custom messages. This is not enabled by default. Integration Services supports a diverse set of log providers, and gives you the ability to create custom log providers. The Integration...
Read More »