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

What are the stages that are required in data warehousing?

964

What are the steps involved in designing a fact table?

891

Explain etl?

980

differentiate between two-tier, three-tier and four-tier connections.

986

Explain true primary keys?

997

What is an i-server?

1057

how do you create schema objects in 2 tier connection?

953

Explain 4gt switch?

898

Explain md doctor?

982

Explain object variable error?

994

What are objects? Name different type of objects in microstrategy?

937

Name different type of objects in microstrategy?

932

What do you mean by trimming sql in microstrategy?

1038

Explain the various types of filters available.

1002

What are the different modes to run i-server?

1062

Un-Answered Questions { Data Warehouse }

What is called cognos reporting tool?

1048

What are the databases that informatica can connect to windows?

1049

What are cluster in redshift? How do I create and delete a cluster in aws redshift?

----------------------What are the User Securities?

1854

How to RD using transformer?

1424

During the running session, output files are created by informatica server. Enlist few of them.

982

What is the sql query overwrite in source qualifier in informatica

1089

What is common among data validity and data integrity?

1060

What are the fundamental blocks of co> operating system of ab initio?

1268

What is de-partition in abinitio?

1363

How can you create a macro variable with in data step? : sas-macro

1039

What is a Pivot?

1147

For clinical entire study how many tables will create approx?

1970

What are the types of presistent cache in look up tr.

2055

What are pass-through functions and why they are so called? Give some examples.

1022

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