Notifications
Clear all

T-Mobile

3 Posts
1 Users
0 Likes
273 Views
Kodapaka Hemanth
(@kodapaka-hemanth)
Honorable Member
Joined: 12 months ago
Posts: 344
Topic starter  
  1. Explain what type of normalization implemented in Star Schema?
  2. Tell about how you deployed your project through project deployment model.
  3. In data warehouse how you handle/implement normalization and denormalization?
  4. Which type of data model you used?
  5. Does duplicate rows fetched by join?
  6. How will you configure your package through XML configuration file?

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

1) Tell me about yourself.

2) Tell me solution and ask me questions regarding this scenerio like what more information you want from the user to provide solution :-Scenerio:We have target table which last 3 years data from Source table but now user want to restage the data of last 12 months in the target table.

3) Have you created database or datamart.

4) what was the largest table have you created.

5) Why you needed that many columns .What all the details were thr in this table.

5) How much time it use to take for the everyday loading process.

6) How many records usually been loaded to target table.

7) Challeges you faced and how you resolved them.

8) Challeges you faced while designing an object.

9) Where you used unix and shell scripting in your project.

10) Team size.

11) Have you worked on any BI tool.

12) Tell me about your last to last project(healthcare project).


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

1) Introduce yourself and detail explanation of last project.

2) Share one schema diagram with me and asked to explain that diagram and check whether that's fully normalize or not? If not then explain with example. Asked more question based on same diagram.

3) Write a query that involves joins between multiple tables that involves aggregate function and view.

4) How to handle error in SSIS.

5) How to avoid joins between multiple tables.

6) If I have to perform total 10 steps in my process within SSIS and my process got failed at step-5. Now, when my process will start to execute again, I want the execution of the process will begin from step-6 directly and from 1st step, What function/feature I can use to achieve this. 

 


   
ReplyQuote
Share: