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 are typees of dimensions

HCL,

11 21074

What is the difference between Open Connection command ang Open Session Command?

2461

what are the debuggings in the business objects?

IBM,

1 4235

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 9951

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 24867

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

Mastek,

6 11220

how to solve many -many relations ship in frame work manager?and how to avoid cartigen product in frame work manager?

HSBC,

8 24001

what is the main role of FI on business

2125

I have 2 structures in universe,but i can't link the structures b'cos no related columns,so what i have 2 do to link dat and if don't link them can i get data of 2 structures in the report that i run?

Wipro,

3 8003

how can we extract data with out having any common column

IBM, Switch2iTech,

7 17433

WHAT are unix quentios in datastage

TCS,

2 20194

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 6290

any body can give hirarchy of bussness object...i mean who will see reports after reports developing is fineshed...then next....

2 5300

cognos reportnet is molap or rolap ... somebady telling cognos reportnet is molap and other will be telling rolap ... i need extract answer

5 9616

One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?

2 6737

Un-Answered Questions { Data Warehouse }

Explain what are the different methods of loading dimension tables?

969

Explain the main difference between inmon and kimball philosophies of data warehousing?

982

Give some ways by which you can define the variables to produce the summary report (using proc report)?

1102

What are the frequently used data types in teradata?

1096

What is connection profile? : sas-grid-administration

1185

how could you generate test data with no input data? : Sas programming

1205

What is the use of dimensional modeling in data warehousing?

997

In my report i want display sales rep name, country ,city how to achieve this by using repeater table

1996

What is the importance of having monitor service in cognos?

1049

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2149

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2254

Explain what are the steps to be taken to schedule the report?

1120

how does sas handle missing values in assignment statements? : Sas programming

1035

Explain do we need an etl tool?

1039

What does sleep function does in fast load?

1157

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