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

Please write codes to merge two datasets and keep every record in the first dataset.

1 4793

When merging 2 datasets with a common variable (not merge key), how to keep both?

3 7030

Write a SAS macro to calculate number of numbers in an email address

2 6458

Write SAS codes to compare two datasets. Suppose the allowable difference is 0.1.

2 7247

Can i create a lookup table without cache.

iGate,

7 11686

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

iGate,

2208

whats the logic to load the lower level of granularity of data to fact table.

IBM,

2281

What exactly mentioned in High level design document.can somebody explain me sequentialy.

IBM,

1 6678

if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

IBM,

2 5806

How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.

IBM,

1 3525

whats the option in informatica 7 version is outdated in informatica 8 version onwards.

iGate,

1 5744

IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?

1 5510

how to find out number of records imported into source file?

1 6817

i have 2 fact and 2 dimension tables in my universe . my question is how get the data with two fact tables in a report?

Cap Gemini,

4 12477

how to prepare the documentation in business objects and where to get the requirement?

IBM, TCS,

2232

Un-Answered Questions { Data Warehouse }

How can you force the optimizer to use a particular index?

1074

How does microstrategy object manager integrate with the microstrategy product suite security model?

947

All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

2107

How you can run a graph infinitely in ab initio?

1596

How can you create a macro variable with in data step? : sas-macro

1053

What is meant by LDAP users?

1219

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1521

What are the factors on which storage of data depends?

1174

What is the difference between metadata and data dictionary?

1154

What do you know about symput and symget?

1265

What is the purpose of pivot stage and types of containers in datastage

1047

How do you determine the number of sessions?

1072

What is defined as partial backup?

1089

What is the profile and package?

2308

What are the stages that are required in data warehousing?

971

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