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 oject manager?

960

Explain microstrategy logical primary keys?

930

Explain three-tier connection?

901

can metadata be manually edited? If yes, how?

988

What do you mean by derived metrics?

944

Explain the difference between rolap and molap?

924

Explain factless facts?

921

Explain attribute?

897

Explain static reports?

959

What are the components required for the application tier?

1 1272

What is the information present in the cognos configuration file?

916

Why are meta service important then other services?

928

How is cognos model organization works?

1028

What is the function of model design accelerator?

916

What is the deployment requirements used in cognos?

1607

Un-Answered Questions { Data Warehouse }

what are relationships?

995

What is meant by Teradata Gateway?

1025

What is spool space? Why do you get spool space errors?

971

Why is sorter an active transformation?

1071

when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

2137

how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance

2059

How can we do data cleaning?

999

What is a ds designer?

1033

What do you understand by a cartesian join?

1069

Explain what is data validation strategies for data mart validation after loading process?

985

What is the function of union transformation?

1081

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2431

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

744

How many types of hash files are there?

1138

How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1107

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