Senior Software Engineer

The following are the primary components of SSRS:
1. Report Builder — This component is essentially a drag-and-drop utility that allows you to select any feature or tables and drag them into place as needed. 
2. Report Designer is a component that allows you to create reports. This component makes it simple to create complex reports. It's a publishing tool that runs in Visual Studio or SSDT (SQL Server Data Tools).
3. Report Manager — We can utilize Report Manager to access any web-based reports.
4. Report Server — The SQL Server Engine metadata is stored in this component.
5. Server database Report : This component is used to hold security settings, report definitions, metadata, and delivery data, among other things.
6. Data Sources - Data is retrieved from data sources such as multidimensional, relational, and traditional data sources by the reporting service components.
Working of SSRS :
The people who utilize the reports are those who work with data and seek to gain insights from it. They send an SSRS server request.
The SSRS server locates the report's metadata and issues a data request to the data sources.
The data from the data source is combined with the report definition to create a report.
The client receives the report once it has been generated.

In SSIS, a Conditional Split Transformation works similarly to an IF condition or a CASE statement. It checks the specified condition and sends the output to the appropriate target path based on the condition outcome. It has a single input and a plethora of outputs.

Merge Transformation is used to merge two sorted inputs into a single output based on the values of the key columns in each data set. Merged columns must have either identical or compatible data types
Merge-Join Transformation is used to merge two datasets into a single dataset using a JOIN function.

There are three different kinds of facts:
Additive facts are those that can be summarized using all of the dimensions in the fact table.
Semi-Additive Facts: Semi-additive facts are those that can be summed up for some but not all of the dimensions in the fact table.
Non-Additive Facts: Non-additive facts are those that cannot be summed for any of the fact table's dimensions.

1. Clustered index is faster. Non-clustered index is slower.
2. Clustered index requires less memory for operations while Non-Clustered index requires more memory for operations.
3. In clustered index, index is the main data. In Non-Clustered index, index is the copy of data.
4. A table can have only one clustered index but it can have multiple non-clustered index.
5. Clustered index has inherent ability of storing data on the disk. Non-Clustered index does not have inherent ability of storing data on the disk.

Degenerate Dimension : A degenerate dimension is when the dimension attribute is stored as part of the fact table and not in a separate table. 
Junk Dimension :To prevent having a high number of foreign keys in the fact table, it is a single table with a combination of various and unrelated qualities. They're frequently made to deal with the alien keys that come with drastically shifting dimensions.

Tip 1 : The cross questioning can go intense some time, think before you speak.
Tip 2 : Be open minded and answer whatever you are thinking, in these rounds I feel it is important to have opinion.
Tip 3 : Context of questions can be switched, pay attention to the details. It is okay to ask questions in these round, like what are the projects currently the company is investing, which team you are mentoring. How all is the work environment etc.