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

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

934

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

896

What are the data types present in bo?

1067

What is meant by metadata in context of a data warehouse and how it is important?

1149

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

997

what is difference between drill & scope of analysis?

1011

Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?

1020

What is the difference between olap and oltp?

989

Can you pass sql queries in filter transformation?

965

What is meant by metadata in context of a data warehouse?

904

What is a data profile?

923

Can a dimension table contain numeric values?

1023

What do you mean by static and local variable?

923

Can any one explain the hierarchies level data warehousing.

948

Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

860

Un-Answered Questions { Data Warehouse }

How do you Parametermap variables in Quiries?

2225

Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??

2565

how many users can open or connect to one of the tm1 web application concurrently?

Explain transformations?

973

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

1908

What is zero-foot print?

979

How co>operating system integrates with legacy codes?

1118

What are the various indexes in teradata? How to use them? Why are they preferred?

1019

What does reusable transformation mean?

1088

What is data mapping and data modelling?

1506

What is fact extension?

1047

What is depict expression change?

1054

What are constraints and derivations?

1130

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4692

what is the difference steps for data modeling?

2547

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