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?

1058

What are the steps to create a data model?

984

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

1094

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

926

What are report filters and view filters?

894

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

822

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

877

How do users receive only information that they want?

925

What is the difference between absolute filtering and standard filtering?

966

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

867

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

949

Difference between project merge and object manager?

954

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

889

What are the supported languages for microstrategy intelligence server?

959

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

981

Un-Answered Questions { Data Warehouse }

How many number of sessions can one group in batches?

1097

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2024

What is metadata in context of a datawarehouse?

969

what are the cubes developed in a sap bw project and what is the requirement for developing it?

2022

Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

915

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2100

how to insert/update a csv file by comparing it with another csv file?

2504

Within a cursor, how would you update fields on the row just fetched?

1025

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

754

which features do you use to check the data validations and errors? : Sas-administrator

1001

What are the advantages of using sas?

1096

any difficulitis have you phase while creating bo reports and how did u solve it

3389

Can schema objects be copied across projects with microstrategy object manager?

936

what is slowly changing dimension? : Sas-di

1067

Difference between output_index and output_indexes in reformat

1230

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