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

After we create a scd table, can we use that particular dimension as a dimension table for star schema?

996

What is dimension modeling?

1088

What is the difference between mapping parameter & mapping variable in data warehousing?

986

Where the cache files stored?

1012

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

1090

How can we run the graph? How can we schedule the graph in unix?

954

What is the difference between star and snowflake schemas?

1213

What is loop in data warehousing?

1141

How do you create surrogate key using ab initio?

996

What are fact, dimension, and measure?

1335

What are the difference between snow flake and star schema?

1006

How can we schedule the graph in unix?

1000

I have two universes created by two difference database can we join them in designer & report level? How

982

What is critical column?

1183

What is "method/1"?

1060

Un-Answered Questions { Data Warehouse }

which date function advances a date, time or datetime value by a given interval? : Sas programming

1048

What is a Transformer?

1077

What are Aggregate tables?

1175

Define views in teradata with syntax.

1077

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1240

What is the difference between fastload and multiload?

1380

What is a fantrap in business objects?

1170

What are the different lookup cache(s)?

1118

What are different types of transformations available in informatica?

991

What are the different ways to implement parallel processing in informatica?

1423

How do you reject records in a transformer?

1124

What is apt_config in datastage?

1139

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

1020

How to stop/start redshift cluster?

If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.

2110

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