1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

What is a table alias in obiee 11g? Where and how will you create it?

 503

How will change port of obiee answers?

 514

How will you create interactive dashboards ?

 515

How will you enable or disable caching in the system level and table level?

 477

How will effect the changes for a report , if for certain users only the column heading in the report should be changed?

 470

How will you do sort in reports in obiee.

 535

What are the different types of variables in obiee 11g? Explain

 475

can you change the location of the obiee repository?

 450

How online/offline mode impact development and delpoyment?

 481

From where u get the logical query of your request?

 472

What are the major challenges you faced while creating the rpd?

 493

What is data modeling and data mining?

 558

What are the ETL Testing Operations?

 628

Explain the use lookup tables and Aggregate tables?

 551

What is data cleaning?

 553

Un-Answered Questions { Data Warehouse }

What is the difference between global temporary tables and volatile temporary tables?

641

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1702

AE datasets names? how many types?

2078

What are fundamental stages of data warehousing?

540

What is the difference between filter and lookup transformation?

618




Is it possible to apply themes to microstrategy web? How?

495

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1529

What are connected or unconnected transformations?

630

Where we use afc in actuate?

539

Explain why are oltp database designs not generally a good idea for a data warehouse?

628

Notification Activity

903

Separate from an archive server and a powerhouse?

499

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

1635

What is surrogate key? Where we use it? Explain with examples.

549

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

716

For More Un-Answered { Data Warehouse } Questions Click Here