Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

Your application mode has crashed. How would you get the instance back?

1008

What do you mean by mstr?

1158

What do you mean by bulk export report?

989

What do you mean by xml cache?

1023

Is it possible to get a floating window in microstartegy web? If yes, how?

1213

Explain fact structure?

1029

What are the different types of mstr objects?

1051

How will you monitor the errors received while running i-server and report?

994

Can you explain surrogate key?

1106

Your application mode has crashed. How would you run your i-server?

1053

What is an i-server? What are the different modes to run it?

1025

How would you increase the logical size of a table in microstrategy?

1026

According to you, what are the most important tables in a dw? Why?

1035

Explain scan md?

1142

Explain fact constellation schema?

1090

Un-Answered Questions { Data Warehouse }

What is the difference between microstrategy and cognos reporting tool?

1055

Define tm1 architecture?

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1902

Can we create multiple integration service on single repository?

1245

How to open a universe with out using the Designer ??

7755

Why is the case expression used in teradata?

1144

what is degenerate key in oracle ?whare do we use it?

2619

What is a source qualifier?

1165

1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

4241

Explain scd type 3 through mapping.

1061

What Is Snow Flake Schema?

1267

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2121

Mention few capabilities of sas framework.

1253

What are the processing stages?

1153

what are the uses of fact table and dimension table in banking project?

4605

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