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 is the syntax for case when statement?

1152

What are the steps to create a data model?

1062

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1170

What formatting can be applied to the information that is sent out by microstrategy narrowcast server?

996

What are report filters and view filters?

958

Is it possible for different nodes of a microstrategy intelligence server cluster to run against different metadata repositories?

926

How can the user determine the object id of an object?

942

How do users receive only information that they want?

984

What is the difference between absolute filtering and standard filtering?

1054

What olap capabilities do I have within a microstrategy report services document?

927

How long does it take to get microstrategy desktop up and running?

1018

Difference between project merge and object manager?

1027

How can users design dashboards quickly and without programming experience or training?

966

What are the supported languages for microstrategy intelligence server?

1022

If a microstrategy intelligence server node is removed from a cluster manually, will report caches be lost?

1073

Un-Answered Questions { Data Warehouse }

what is sas application server? : Sas-di

1086

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

What is the syntax for m_dump in abinitio?

1628

What are the names of the layers in etl?

1002

4. How many dimensions did you use in your reports?

1956

What are the different transaction levels available in transaction control transformation?

1213

Explain why double trailing @@ is used in input statement?

1074

What are the features of ab initio?

1114

Explain is fact table?

939

how to add a new records into source?

2002

What are data validation strategies for data mart validation after loading process?

1022

What is Discrete and Continuous data in Data mining world?

2647

How can you set the client management?

1022

Difference between output_index and output_indexes in reformat

1299

What is fact less fact table? Where you have used it in your project?

1013

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