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

How to startup obiee in linux?

891

What is clusterservices in obiee ? Why its used?

924

How will you create report from two subject areas

834

how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.

873

What is write-back in obiee ?

833

Explain the architecture of obiee and what each components do?

859

What are the different layers of obiee repository?

1 1242

How analytics process your request when you create your requests?

939

Can you run multiple rpd’s in a single obiee instance?

790

What are the different log files in obiee?

962

How will you go about adding additional column to the repository in the presentation layer?

925

What you will do when your report is not fetching right data?

929

What is star schema and snowflake schema?

993

What are the different types of variables in obiee? Explain

906

what is guided navigation?

900

Un-Answered Questions { Data Warehouse }

What do you mean by tpt in teradata?

1021

What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?

1184

Define Dynamic push down optmization?

2306

What is joiner transformation?

1010

What is a real-time data warehouse?

998

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4161

Why we use surrogate key?

1236

What are parallel querys and query hints?

2232

What’s the difference between var b1 – b3 and var b1 — b3?

1366

Explain batch processing in ab initio?

1458

How to improve session performance in aggregator transformation?

984

What is program data vector (pdv) and what are its functions?

1250

define the logic behind the sparsity in cubes?

What is a bridge table ?

888

what is hints in cognos and where we use it.

2455

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