There is a table named GEO, having state and city as it's attribute! Write a query to select the states having the same corresponding city?
Bi Developer Interview Questions
1,368 bi developer interview questions shared by candidates
1. What is the difference between WHERE and HAVING Clause? And when we use where or Having explain with an example? 2. Write a query to find 3rd Maximum salary ? (Easy one) 3. Explain Normalization Types? 4. What is the difference between OLAP and OLTP? 5. Interviewer Provide me a scenario for query writing, I think it was like " Find those employees whos Average salary is greater than 100k department wise" 6. What is the difference between Union and Union ALL? 7. What is the difference between Delete and Truncate statement? 8. Difference between Fact and Dimensions? 9. Different type of Joins? 10. Types of SCD with Example?
Please help to Introduce yourself
How will you bring data in power bi desktop from SQL database
Describe some ways to improve performance on large table
What is Dax and how to use?
I was asked several questions based on the results of the personality test
Data Warehousing, ETL, SLQs, Cognos BI, Cognos Report Studio, Cognos Framework Manager, Cognos Transformer, Dimensional Modeling, Dimensional Functions, etc.
how to manage time inteligence functions in direct querry mode
goals where you are in feature
Viewing 31 - 40 interview questions
See Interview Questions for Similar Jobs
Business Intelligence EngineerBi ManagerSsis DeveloperSql Server DeveloperBusiness Intelligence DeveloperSql DeveloperBi AnalystBusiness Intelligence AnalystEtl DeveloperSiebel DeveloperMicrostrategy DeveloperEdi DeveloperBi Project ManagerSenior Sharepoint DeveloperBusiness Objects DeveloperBi Consultant