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

2403

COM components can be used in Informatica

2398

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

Wipro,

1 6399

When will you use SQL override in a lookup transformation?

1 5804

Two different admin users created for repository are ______ and_______

1 4384

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

2 7562

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

1 4725

What is a code page in Informatica

American Express, Cognizant, Deloitte,

3 17251

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

Accenture,

1 10727

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 14288

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 4100

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 9394

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

2423

Usage of Stored Procedures in Cognos

General Motors GM, TCS,

1 3835

What is scope of analysis ?

L&T,

3 8538

Un-Answered Questions { Data Warehouse }

What is the report studio?

1023

---------------Describe OLAP Reporting and RDBMS Reporting?

2109

how the sas basic syntax style described? : Sas-administrator

1024

in the flow of data step processing, what is the first action in a typical data step? : Sas programming

1081

what is object level locking ? where do appear this type of locking ?

3503

What are the main issues while working with flat files as source and as targets ?

1168

What is the difference between absolute filtering and standard filtering?

1053

in reporting we add some new objects,how we get the count of the newly added objects to the report

2201

How to convert multiple rows to single row (multiple columns) in informatica

1387

Which studio is used to create reports?

1115

AWS Redshift is basically works on nodes and cluster and which of following option Redshift is based on?

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1630

What is the difference between an operational datastage and a data warehouse?

1157

What are the join problems comes appart from loop,chasm & fan Traps

2141

Can we test the report other than manual testing?

2179

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