Application of Row_Number, Rank, and Dense Rank? Different stages of defects/Bugs? What are Schema objects? Different types of loads in ETL Testing? What is Junk Dimension? SQL to remove duplicates from a table? Nth highest salary finding from a table's data? SCD2 type test cases? What are the types of facts? What is KPI? Smoke vs Sanity testing?

Question

Accepted Answer

Interview questions on SQL and ETL testing

Row_Number, Rank, and Dense Rank are used for ranking and ordering data in SQL
Defects/Bugs can be classified into different stages such as Open, In Progress, Resolved, Closed, etc.
Schema objects are database objects such as tables, views, indexes, etc.
Different types of loads in ETL Testing include Full Load, Incremental Load, and Delta Load
Junk Dimension is a dimension table that contains low cardinality columns
SQL to remove duplicates from a table: SELECT DISTINCT column1, column2 FROM table_name
Nth highest salary can be found using the SQL query: SELECT DISTINCT salary FROM employee ORDER BY salary DESC LIMIT n-1,1
SCD2 type test cases involve testing the updates and historical data in a slowly changing dimension
Types of facts include Additive, Semi-Additive, and Non-Additive facts
KPI stands for Key Performance Indicator and is a measurable value that indicates how well an organization is achieving its goals
Smoke testing is a quick and shallow testing to ensure that the basic functionalities of an application are working, while Sanity testing is a more thorough testing to ensure that the major functionalities of an application are working after a change or update

Accepted Answer

The RANK(), DENSE_RANK(), and ROW_NUMBER() are window functions that return the row numbers based on the partition and the ORDER BY clause. Note that, because all these functions are window functions, they reset every time a new partition occurs

Top Cognizant Senior Associate interview questions & answers

Popular interview questions of Senior Associate

Top HR questions asked in Cognizant Senior Associate