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?

AnswerBot
1y

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, ...read more

bhartiagake
6mo
student at
Pune University
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,...read more
Help your peers!
Add answer anonymously...
Cognizant Senior Associate Interview Questions
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+

Reviews

4 L+

Interviews

4 Cr+

Salaries

1 Cr+

Users/Month

Contribute to help millions
Get AmbitionBox app

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter