MSBI Interview Questions: Update query, Conditional Split, Loop, Query

1. Update query to change male to female

Before Updation

Query:-

update [dbo].[Detail]

set

[Gender]= CASE WHEN [Gender]=’Female’ then ‘Male’ ELSE ‘Female’ END

After Updation

2. Conditional Split

Conditional split is a component of SSIS. It is like if condition or case statement.

Conditional split checks the condition and as per condition data can be pass to destination.

Conditional Split In SSIS

Original Table

Male Table Data

Female Table Data

3. For loop and For each loop container in SSIS

For loop execute task a specified number of times.

For each loop traverse and load multiple files.

4. Co-related Query and Sub Query

Co-related Query:-

The inner query needs to value the outer query then that result pass to the outer query.

Sub Query:-

The subquery is a query under query.

Start with MSBI video as mentioned below to learn topic practically in-depth: