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?

951

What is dimension modeling?

1004

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

945

Where the cache files stored?

974

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.

1047

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

905

What is the difference between star and snowflake schemas?

1139

What is loop in data warehousing?

1090

How do you create surrogate key using ab initio?

955

What are fact, dimension, and measure?

1267

What are the difference between snow flake and star schema?

962

How can we schedule the graph in unix?

951

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

938

What is critical column?

1126

What is "method/1"?

991

Un-Answered Questions { Data Warehouse }

Can you explain cognos planning?

1056

What are the new features included in the new version of SAS Programming Language?

1168

differentiate between two-tier, three-tier and four-tier connections.

950

How to generate sequence numbers using expression transformation?

1040

my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...

4157

Explain the features of connected and unconnected lookup.

893

How do you delete duplicate observations in sas?

1036

Why redshift Distribution key is used?

what is SAS OPTIMIZATION?

2255

Why sorter is an active transformation?

1146

What is Operational Data Store?

1019

Explain the importance of data warehouse?

957

What is the difference between ods and oltp?

968

Which command is used to save logs in the external file?

1048

What are pdv and it functions?

1071

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