Deloitte Interview Questions:
1)
Tell me about your profile
2)
What is Request variable?
3)
Does if null statement works in
pivot table view.
4)
What are the performance
techniques you have used in your project?
5)
What all the things you take
into consideration while giving efforts estimation to Business?
6)
How does Partition work in
obiee?
7)
Can we use physical join in BMM
layer?
8)
Can we use complex join in
Physical layer?
9)
Difference between OBIEE 11g
and OBIEE 10g?
10)
What is degenerate Dimension?
11)
What is a request variable?
12)
How do you migrate reports
without Catalog Manager?
13)
I Have three 2 facts and one
aggregate table in a report, now the problem is taking long time to show up
results. The report is picking up all the columns from fact tables. Now, how do
you improve the performance?
14)
What are types of Schema’s in
Data warehouse?
15)
Did you implement any new
initiative or new solution you implemented in your current project?
16)
Did you implement MUDE
environment?
17)
How do you migrate RPD?
18)
What are the different types of Hierarchies introduced
in OBIEE 11g? Explain them?
19)
What is the use of aliasing?
20)
Have you worked on upgrading
OBIEE 10g to OBIEE 11g?
21)
Explain the architecture of
OBIEE 11g?
22)
Why can’t we use update
strategy transformation anywhere in the mapping? What are the restrictions?
23)
Explain SCD type 2 logic. Tell
me the example where you have implemented in your project?
24)
What is the difference between stop and Abort
in Informatica?
25)
Why refresh dates used in DAC?
And where do you set up?
26)
Can we go for a full load in
production environment using DAC?
27)
Where else you can setup
refresh dates in DAC?
28)
How do you add task to subject
area and where do you do it in DAC?
29)
What is Prune Days? What is the
use of it?
30)
What is difference between
initial Extract date and Last extract date?
31)
Can you run few tasks full
load? How to do it in DAC?
32)
What are the modules you have
worked on? Tell me financial fact tables you have used?
33)
What is the critical report you
have worked on?
34)
By Default what will DAC
do? Whether Full load or incremental
load?
nice post Swathi
ReplyDelete