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 21467

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

1 2535

what are the debuggings in the business objects?

IBM,

1 4319

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 10141

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 25265

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 11435

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

HSBC,

8 24324

what is the main role of FI on business

1 2170

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 8180

how can we extract data with out having any common column

IBM, Switch2iTech,

7 17713

WHAT are unix quentios in datastage

TCS,

2 20351

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

2 6392

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

2 5430

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

5 9829

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 6857

Un-Answered Questions { Data Warehouse }

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

847

What is the difference between business requirement document and use case document.

1086

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2313

Hi, If anyone has base SAS certification dumps, please share.

1940

Explain in detail about scd type 1 through mapping.

1646

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8288

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3446

Explain how to generate iqd file from framework manager?

1022

What is dimensional table?

1167

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2175

What is aggregate table and aggregate fact table ... Any examples of both?

1119

how to generate the test data in sas without input data? : Sas-administrator

1207

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2306

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1964

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2344

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