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?

960

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

935

What are the data types present in bo?

1128

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

1204

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.

1035

what is difference between drill & scope of analysis?

1091

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

1066

What is the difference between olap and oltp?

1057

Can you pass sql queries in filter transformation?

1018

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

963

What is a data profile?

974

Can a dimension table contain numeric values?

1058

What do you mean by static and local variable?

963

Can any one explain the hierarchies level data warehousing.

992

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

904

Un-Answered Questions { Data Warehouse }

Can you define slice?

1034

What are the different common services in datastage?

1285

generate date / time dimension in informatica

1125

How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2427

What is data analysis? Where it will be used?

986

What are dimensions?

1060

Can you use flat files in Mapplets.

2651

Explain what is the architecture of abinitio?

1215

What is a grid in Informatica?

1069

Explain standard filters?

1005

Mention a few design and development best practices for informatica?

997

What is flashback table ? Advance thanks

1936

what can you learn from the sas log when debugging? : Sas programming

1089

Compare etl & elt?

1012

Explain scd type 3 through mapping.

1006

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