Notifications
Clear all

Virtusa

6 Posts
2 Users
0 Likes
102 Views
Kodapaka Hemanth
(@kodapaka-hemanth)
Honorable Member
Joined: 12 months ago
Posts: 344
Topic starter  

1) Introduction

2) overview of first project

3) scenario based SSIS questions on that

4) Normalization

5) Denormalization

6) difference between udf and SP

7) asked me to write queries and read it out loud... almost 7-8 queries

8) questions from my side

9) summarized


   
Quote
Kodapaka Hemanth
(@kodapaka-hemanth)
Honorable Member
Joined: 12 months ago
Posts: 344
Topic starter  

1. Introduction

2. Project Story

3. How to identify slow running queries

4. Performance tuning of T-SQL

5. 3 scenario based queries

6. Difficult situations and how did you solve it?

7. How do you write a query from two or more different data sources (like Oracle, MS Sql, My Sql)


   
ReplyQuote
Kodapaka Hemanth
(@kodapaka-hemanth)
Honorable Member
Joined: 12 months ago
Posts: 344
Topic starter  
  1. Data integrity and Consistency in DW .Data integrity in Dimension .
  2. How define the table and normalization in the DW.
  3. Some real time scenario questions on DW.
  4. What is the use of denormalization ?
  5. Where and why we use?
  6. Which layer od data used for SSRS?
  7. What are the basic event handlers to every PKG?
  8. What SCD and why and where we apply in real time?
  9. Other ways to do Incremental loading?
  10. Difference b/w Merger and Merge join and where will use in real scenario?
  11. Examples of Containers?
  12. How to handle duplicate records?1-2 real time scenario question on SSIS?

   
ReplyQuote
Kodapaka Hemanth
(@kodapaka-hemanth)
Honorable Member
Joined: 12 months ago
Posts: 344
Topic starter  
  1. Introduction
  2. Project Story
  3. Scenario on many to many relationship
  4. what is normalization and disadvantages of it Shared my screen and ask me to write 7-8 queries
  5. How to create temp Stored procedure.
  6. Can you join two tables without using joins and relationship
  7. What is SQL Commands

   
ReplyQuote
Kodapaka Hemanth
(@kodapaka-hemanth)
Honorable Member
Joined: 12 months ago
Posts: 344
Topic starter  
  1. Introduction to my Project  What are some of the transformations used in your Project and explain the scenario where and how used?
  2. What is your project Deployment  approach
  3. What is reverse engineering? Have you done on any project?
  4. what is your approach  towards troubleshooting?
  5. What are the TSQL scripts used in SSIS explain the scenario in your project?
  6. Have you used Script Task in your recent project and explain the scenario where and how used ?

   
ReplyQuote
prasanthi
(@prasanthi)
New Member
Joined: 2 months ago
Posts: 1
 

1. Introduction

2. Project Story

3. Your role in project?

4. What is data blending?

5. What are groups?

6. One user have access for 5 filters, another user has access for 3 filters only. How do you implement access?

7. What domains you used in data blending?

8. In Banking domain, how did you implemented consumer banking analysis and how it helped the user?

9. Your license in tableau server has expired. Can user still able to see your dashboards?

10. In Retail domain what is the use of Brand analysis and how user can apply analysis report to implement sales and inventories ?

11. Write a SQL query to get 10th highest salary in employee table?

12. Asked about CSS and HTML knowledge

13.How to give user authentication in tableau server?

14. Do you attend client calls/direct interaction with clients

 

 

 

 


   
ReplyQuote
Share: