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 difference between sas functions and procedures?

1075

What are all the different types of prompt in cognos?

998

What are the types of folder present in cognos?

1057

What do you mean by drill through report?

924

What do you mean by drill across?

1086

What is defined as data mining?

974

When we save a report in report studio with what extn it save?

1005

What are all the types of hierarchies?

1090

What is called cognos reporting tool?

992

What are the ways to import data into catalog?

1025

What is the use of cognos decision stream?

1043

What is set to be cardinality?

1118

Mention the difference between ‘macros’ and ‘prompt’?

1065

What are the components of report net?

1194

What is the difference between metadata and data dictionary?

1069

Un-Answered Questions { Data Warehouse }

Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

927

How would you include common or reuse to be processed along with your statements?

2324

Why update strategy and union transformations are active? Explain with examples.

1180

When we save a report in report studio with what extn it save?

1005

What are the batches and it’s details?

920

What are the mapping parameters and mapping variables?

1098

What is the difference between aggregate table and materialized view?

1035

What is a filter transformation and why it is an active one?

916

how do u really know that paging to disk is happening while u are using a lookup transform?

2385

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1839

Differentiate between sessions and batches?

969

What is fact degradation?

921

In document how to create metrics?

941

Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1890

Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

951

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