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

What is difference between user and database in teradata?

1121

What is the difference between fastload and multiload?

1467

What is real time and near real time data warehousing?

1164

What is dimensional modeling?

1145

What are the multiload utility limitations?

1117

What is a sparse index?

1127

Can we collect statistics on table level?

1100

What interface is used to connect to windows based applications?

1179

What is primary index and secondary index?

1075

How many bi services node can be clustered together?

925

What is level based metrics.how will you create it?

943

How to get sql from obiee for reports?

933

Have you created hierarchy in obiee. If so where and how?

923

How will you do different types of narrative reports in obiee?

950

How the users created differs from rpd/answers/dashboards level?

856

Un-Answered Questions { Data Warehouse }

What is a bridge table ?

958

update strategy transformation in informatica

1126

i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

2053

Explain teradata utilities. What is multiload, fast load, tpump?

1049

Explain if a flat file cotains 1000 records how can I get first and last records only?

972

What is set to be cardinality?

1234

How to create model and how to test model?

1080

Explain the term 'primary key' related to relational database management system?

1091

What is the difference between SAS functions and procedures?

1190

What are the conditions needed to improve the performance of informatica aggregator transformation?

1142

How analytics process your request when you create your requests?

1000

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6284

What is model filter?

1325

how we can load rejected record's at run time?(not through bad files)

2435

How to convert multiple rows to single row (multiple columns) in informatica

1429

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