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

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1 2461

COM components can be used in Informatica

1 2485

What is the advantage of persistent cache? When it should be used.

Wipro,

1 6525

When will you use SQL override in a lookup transformation?

1 5899

Two different admin users created for repository are ______ and_______

1 4467

Two Default User groups created in the repository are ____ and ______

2 7671

A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 4829

What is a code page in Informatica

American Express, Cognizant, Deloitte,

3 17454

What is #refresh,#hash,#Comupation error and How to resolve #refresh,#hash error.

Accenture,

1 10833

i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output aaa bbbb ccccc Ple help any one?

SLK Software,

4 14518

Hi , which book should i refer to for preaparing SAS statistical Exam. Searched a lot on books but still did n't find relevant books

2 4226

If you have a report with list and cross tab in the same page. How do you restrict one user can see only the list and the other user can see both.

IBM,

4 9591

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2495

Usage of Stored Procedures in Cognos

General Motors GM, TCS,

1 3934

What is scope of analysis ?

L&T,

3 8703

Un-Answered Questions { Data Warehouse }

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

2344

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2213

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2169

explain in detail about type 3?

1091

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2772

Explain about a tricky situation for which you found a very simple solution?

1081

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

2306

How do you remove duplicate records in informatica? And how many ways are there to do it?

1234

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2550

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

2176

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

1178

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1853

Are you involved in writing the inferential analysis plan? Tables specifications?

4019

what is document design in boxi,have u participate in that

2308

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

3447

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