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 enterprise class platform architecture of cognos 8?

1029

What are the services provided in cognos 8?

1032

Explain the different types of views used in cognos.

949

What are the main services provided by application tier?

981

What are the roles defined by cognos platform?

1150

What is the importance of having monitor service in cognos?

1036

What are the considerations regarding performance kept in mind while setting up cognos?

967

What are the components used in web tier?

992

What is the difference between low affinity and high affinity connections?

1019

What are the different types of important services used in cognos?

1018

What is the function of cognos dispatcher?

1214

What is the use of powerplay web viewer in cognos?

1089

What are the different kinds of panes included in cognos?

1057

Why is auto-regression used in forecasting used on cognos platform?

1021

What is a folder? Difference types of stages?

1177

Un-Answered Questions { Data Warehouse }

What is the difference between the public object&schema object?

1065

Why are oltp database designs not generally a good idea for a data warehouse?

1056

How to add default rules in the transformer?

1230

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1045

What is Redshift Enhanced VPC Routing?

What are the different types of important services used in cognos?

1018

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

1043

How to use pmcmd utility command?

1032

In BTEQ, how are the session-mode parameters being set?

1143

how can we create rank using datastage?what is the meaning of rank?

8794

Difference between cold fusion 5 and cold fusion mx 6?

995

Explain do we need an etl tool?

1017

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4044

What is the command used to run a batch?

1063

Why does microstrategy object manager search for object dependencies?

971

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