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

Explain system call error?

1009

what are the criteria used by the microstrategy sql engine to build the join tree of a report’s sql?

951

You have got the requirement from a client. Explain the technical approach you will take now.

971

Explain about compound key?

1080

Explain clustering?

977

Your application mode has crashed. A.) How would you run your i-server? B.) How would you get the instance back?

899

Explain security role?

939

Explain attribute role?

1079

Compare dataset and fileset?

1039

What are objects?

1018

Explain 4gt switch. Does it have any drawback?

967

Explain confirmed dimensions. When are they used?

982

Is it possible to limit the number of reports run by a users at a time? How? What will happen if this limit is exceeded?

1029

What is the effect of dls on microstrategy?

1003

What do you mean by staging area?

972

Un-Answered Questions { Data Warehouse }

What is model?

967

How do we resolve attribute roles in microstrategy?

1151

What is Index Caches size?

1114

How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

1047

What’s the use of redshift?

Steps to create a data model?

1132

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2000

How to create a repository in abinitio for stand-alone system(local nt)?

1118

What is session task and command task?

1294

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2057

What is bteq script in teradata?

1155

Explain what are the advantages and disadvantages of reporting directly against the database?

1002

What are the types of containers in datastage?

1191

What is the purpose of _character_ and _numeric_?

1068

what is the function of catx syntax? : Sas-administrator

1101

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