Filter interviews by
I applied via LinkedIn and was interviewed in Jun 2024. There were 2 interview rounds.
Normal apti question
I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.
SCD types refer to slowly changing dimensions in data warehousing, categorized into Type 1, Type 2, and Type 3.
Type 1 SCD: Overwrites existing data with new information, losing historical data.
Type 2 SCD: Maintains historical data by creating new records for changes, with a surrogate key for each version.
Type 3 SCD: Keeps both old and new values in the same record, with separate columns for each version.
A junk dimension is a single dimension table that combines multiple low-cardinality attributes that are not related to the fact table.
Contains attributes that are not related to the fact table
Reduces the number of dimension tables in the data warehouse
Helps in simplifying the data model and improving query performance
Snowflake schema is a normalized form of star schema with multiple levels of dimension tables.
Snowflake schema has normalized dimension tables, leading to reduced redundancy and improved data integrity.
Star schema has denormalized dimension tables, which can lead to data redundancy but faster query performance.
Snowflake schema is more complex to query compared to star schema due to multiple levels of normalization.
Star...
Nice Software Solutions interview questions for popular designations
Online SharePoint Aptitude Test.
On mail they send and need to submit file
I applied via Naukri.com and was interviewed before Sep 2023. There was 1 interview round.
Types of LOD in Tableau include Fixed, Include, and Exclude.
Fixed LOD: Computes a value using a specific dimension without reference to the view level
Include LOD: Computes a value at a specified dimension level
Exclude LOD: Computes a value at a specified dimension level excluding the dimension specified
Types of filters used in Tableau include extract filters, context filters, data source filters, and quick filters.
Extract filters are used to filter data before it is extracted into Tableau.
Context filters are used to filter data in a specific order, affecting subsequent filters.
Data source filters are applied at the data source level, affecting all workbooks and views using that data source.
Quick filters allow users t
In the assignment, you are provided with
1. Raw content in PPT for that, you need to create an Animated slide with Voice Over sync.
2. One scenario for that you need to implicate that with graphics in Storyline 360 with Text 2 Speach audio and triggering
I applied via Other and was interviewed in Apr 2021. There was 1 interview round.
Control flow and data flow are two important components of SSIS. There are various types of transformations available in SSIS.
Control flow is used to manage the flow of tasks and containers in a package.
Data flow is used to extract, transform, and load data from various sources to destinations.
Transformations are used to modify data during the ETL process. There are various types of transformations such as Aggregate, D
I applied via Approached by Company and was interviewed before Jun 2021. There was 1 interview round.
Different types of joins in SQL include inner join, left join, right join, and full outer join.
Inner join returns only the matching rows from both tables
Left join returns all rows from the left table and matching rows from the right table
Right join returns all rows from the right table and matching rows from the left table
Full outer join returns all rows from both tables, with NULL values for non-matching rows
WHERE clause filters rows before grouping, while HAVING clause filters groups after grouping.
WHERE clause is used to filter rows based on a condition before grouping.
HAVING clause is used to filter groups based on a condition after grouping.
WHERE clause is used with SELECT, UPDATE, DELETE statements.
HAVING clause is used with GROUP BY clause.
WHERE clause cannot contain aggregate functions.
HAVING clause can contain aggr...
Top trending discussions
based on 10 interviews
Interview experience
based on 83 reviews
Rating in categories
BI Consultant
57
salaries
| ₹5.3 L/yr - ₹15 L/yr |
Associate Consultant
49
salaries
| ₹4.2 L/yr - ₹12.4 L/yr |
Associate BI Consultant
32
salaries
| ₹4 L/yr - ₹11 L/yr |
Consultant
31
salaries
| ₹6.4 L/yr - ₹26.5 L/yr |
Senior BI Consultant
29
salaries
| ₹7.2 L/yr - ₹24.8 L/yr |
TCS
Infosys
Wipro
HCLTech