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 21059

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

2458

what are the debuggings in the business objects?

IBM,

1 4230

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 9947

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 24858

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 11211

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

HSBC,

8 23988

what is the main role of FI on business

2120

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 8000

how can we extract data with out having any common column

IBM, Switch2iTech,

7 17424

WHAT are unix quentios in datastage

TCS,

2 20191

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

2 6285

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

2 5298

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

5 9605

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 6736

Un-Answered Questions { Data Warehouse }

What is sorter transformation?

1064

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

943

What are some prerequisites for datastage?

1112

Mention few power centre client applications with their basic purpose?

962

how to write server Routine coding?

2137

Describe in detail about lookup?

1096

How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa

1086

Explain input and put function?

1151

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2199

Explain where do we use semi and non additive facts?

1031

How is MLOAD Teradata Server restarted after execution?

1280

I have two universes created by two difference database can we join them in designer & report level? How

997

What is Index Caches size?

1129

Explain er diagram?

1001

what is broad cast agent? : Sas-bi

1083

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