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

Mention what are the data types does SAS contain?

1155

Can we create multiple integration service on single repository?

1197

How would you join a node to the already existing domain?

1132

What is primary and backup node?

1137

Define pmcmd command?

1049

How to go to the older version for a mapping?

1103

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 1870

What is meant by LDAP users?

1214

What is a shortcut and copy in Informatica and how two are different with each other?

1202

What is exclusive and normal mode for repository services?

1150

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1161

What is a grid in Informatica?

1077

Can we create a Integration service without a Repository service and vice versa?

1218

What is deployment group?

1221

What are roles and groups and benefits of using them?

1058

Un-Answered Questions { Data Warehouse }

Where do we use mapping variables in informatica?

1075

Tell e how how dealt with..

2227

In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?

2246

Explain degenerate dimension table?

1053

Why is business intelligence (bi) important in data warehousing?

949

how do you manage the production space. what are the proactive methods you can take ?

1952

Give some examples where proc report’s defaults are different than proc print’s defaults?

1079

What is aggregate cache in aggregator transformation?

1151

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

2159

If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

964

How are numeric and character missing values represented internally?

1665

what is sas application server, database server, sas olap server and sas metadata server? : Sas-di

1021

Explain access control?

1013

Have you used rollup component? Describe how.

1077

Explain the definition of normalized and denormalized view?

903

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