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

explain about dirty dimension?

1094

What is drilling across?

942

What are the different types of segments?

925

Explain the hierarchies level data warehousing.

850

What is the difference between junk dimension and degenerated dimension?

1053

What are data modeling and data mining? Where it will be used?

942

How much data hold in one universe.

944

What are the differences between star and snowflake schema?

1030

What is the data type of the surrogate key?

945

How can you implement many relations in star schema model?

955

How can you import tables from a database?

1022

What are the different types of data warehousing?

905

What is the main difference between inmon and kimball philosophies of data warehousing?

1080

What is data analysis?

908

What is core dimension?

1001

Un-Answered Questions { Data Warehouse }

Explain about compound key?

999

What is a Decision Tree Algorithm?

4960

Can we configure two instances of CMS pointing to two different CMS system databases?

1985

What is slibref?

1221

Explain what are necessary tasks to install reportnet software?

873

Design a mapping to load a target table with the following values from the above source?

1307

Explain what are slowly changing dimensions?

982

How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?

4357

What kind of layouts does abinitio support?

1228

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2526

How to enable drills in a given column data?

815

What is the difference between drill through, drill across?

1036

How to drill through from a powerplay cube to reportnet?

887

Name types of category in which SAS Informats are placed?

1113

What is a router transformation?

1068

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