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?

971

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

904

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

912

Explain about compound key?

996

Explain clustering?

905

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

868

Explain security role?

883

Explain attribute role?

1015

Compare dataset and fileset?

989

What are objects?

954

Explain 4gt switch. Does it have any drawback?

927

Explain confirmed dimensions. When are they used?

940

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?

984

What is the effect of dls on microstrategy?

935

What do you mean by staging area?

909

Un-Answered Questions { Data Warehouse }

What is de-partition in abinitio?

1333

What is the difference between datastage and datastage tx?

1027

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

967

What are level metrics? Why are they needed?

997

What are the scrubbing procedures in sas?

962

What are the 5 phases in a multiload utility?

1000

What are the reusable transformations?

1115

Describe the between keyword in teradata?

998

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2097

Does microstrategy intelligence server support scheduling?

996

What are the supported languages for microstrategy intelligence server?

973

What exactly do you understand with the term data processing and businesses can trust this approach?

1057

I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?

2024

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1947

What are the differences between oltp and olap?

934

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