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?

1067

What is the difference between fastload and multiload?

1380

What is real time and near real time data warehousing?

1118

What is dimensional modeling?

1085

What are the multiload utility limitations?

1055

What is a sparse index?

1084

Can we collect statistics on table level?

1035

What interface is used to connect to windows based applications?

1114

What is primary index and secondary index?

1028

How many bi services node can be clustered together?

873

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

877

How to get sql from obiee for reports?

884

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

889

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

901

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

816

Un-Answered Questions { Data Warehouse }

How to use procedural logic inside infromatica?

1236

What is incremintal loading?

1112

What is status code in informatica?

1020

I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

2283

What is the difference between in process and inter process?

1146

Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?

2250

What is the metric store database?

969

What is the difference between teradata and oracle?

1027

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

1060

Explain standard filters?

1003

Explain grouped cross tab?

2626

hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana

5451

Define Merge?

1317

Write the different tools in the workflow manager?

1066

How many project sources we can create in metadata?

1091

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