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

I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

TCS,

2 9890

where we use column generator stage in real time scenario?

TCS,

5 27112

What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh

ACS,

6 14193

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...

2110

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com

2120

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

Accenture, HCL,

6 17949

i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

2053

describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

2373

my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

2051

wt is the differnce between Block & conditional block ?

2 17765

wt is scope relationship?

2 7523

How can we create regular dimensions & measure dimensions?

2 6022

Wt is the Diff between Business Key & member caption?

2 31574

It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

2524

How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

3351

Un-Answered Questions { Data Warehouse }

What is the difference between global temporary tables and volatile temporary tables?

1244

Explain why dimenstion tables are denormalized in nature?

981

Explain the etl program with few examples.

1115

Your application mode has crashed. How would you run your i-server?

1051

Are you involved in writing the inferential analysis plan? Tables specfications?

2270

What is the use of stop statement?

1123

How can you force the optimizer to use a particular index?

1133

Explain true primary keys?

1054

In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?

2310

What are the data types present in bo? What happens if we implement view in the designer n report?

996

How do y read Sequential file from job control?

16085

Is it possible to create multiple domains on a single Informatica server?

1291

differentiate between view and materialized view?

What are the advantages of using cognos sql?

1251

What is the difference between agglomerative and divisive hierarchical clustering?

1248

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