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 OLAP?

CitiGroup, TCS,

4 10564

what is information maps?

CitiGroup,

2221

how to intersect the tables by using PROC MIXED?

CitiGroup,

1 8226

Tell me one example for multi valued dimension or bridge table?

Accenture, CMC, IBM, Logica CMG, TCS,

2 18998

Tell me one example for junk dimension?

TCS,

9 45637

what is mean by cognos powerhouse?

TCS,

1 6041

what is an associated query?

2 6054

What is the difference between procedure and stored procedur?

IBM,

2 8300

What is a taget load order?

IBM,

2 8921

what are the perameter and variable?

IBM,

3 8149

Differnce between filter and router?

IBM,

14 40985

what is mean by complex starschema ,star schemagrouping?

1934

What is difference between Business Objects and Hyperion Essbase? Please help me

Cap Gemini, TCS,

1 14728

Can anyone tell me which automation tool is used in cognos,is it a testing tool or performance enhancing tool Thanks in advance

SAP Labs,

2 5163

who r the users in B.O.XIR2?

PCS,

2 7307

Un-Answered Questions { Data Warehouse }

Can you pass sql queries in filter transformation?

1017

What are various types of gateways in cognos?

1058

------------------What is Inline Query?

2223

Explain how to import oracle sequence into informatica?

1011

What are the various indexes in teradata? How to use them?

1012

Can you explain how could anyone drop the index before loading the data in target in datastage?

1504

How to restrict password to a user while sending a document in .pdf format

2341

How to manage date conversion in Datastage?

1136

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1113

Write the advantages of partitioning a session?

1282

What is load manager?

1039

What are the types of containers and how to create them?

976

What is meant by lookup transformation?

1107

What are the difference types of stages?

1214

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

4160

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