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

suppose the network connection between a webserver and clustered i-server gets lost. What will happen? Will the report still run?

977

Explain four-tier connection?

932

Explain star schema?

978

How do you achieve schema object version control?

999

What do you mean by consolidations?

1041

Explain the difference between holap and rolap?

979

Explain fact table?

1050

Explain absolute filter?

970

what are the different authentication modes available in microstrategy?

1107

What is a dw? Why do we need it?

976

Explain adhoc reports?

937

How would you configure wh authentication?

952

Imagine this, you are required to reset the password for all users at a time. How would you do that?

951

What are prompted filters? Have you ever used them? Where?

986

Can a record be inserted and updated in database using microstartegy?

930

Un-Answered Questions { Data Warehouse }

What are the repository tables in datastage?

1306

Differentiate input and infile.

1102

How conflicts occur and what are the ways to resolve them?

941

What is target designer and target load order?

1103

Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

2445

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1538

How to convert a numeric variable to a character variable?

1209

How many input parameters can exist in an unconnected lookup?

1545

What is analytical or analytic mean?

1127

What is the use of virtual processor connectivity in teradata?

1026

Explain proc sort?

1106

What are the advantages and disadvantages of reporting directly against the database?

982

Ist the schema that a data warehouse system can implements.

940

Explain pmcmd command usage in informatica

1131

How can you define user defied event?

1030

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