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?

1198

Can we create multiple integration service on single repository?

1245

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

1190

What is primary and backup node?

1179

Define pmcmd command?

1112

How to go to the older version for a mapping?

1171

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

1 1970

What is meant by LDAP users?

1296

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

1245

What is exclusive and normal mode for repository services?

1199

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

1218

What is a grid in Informatica?

1124

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

1260

What is deployment group?

1306

What are roles and groups and benefits of using them?

1116

Un-Answered Questions { Data Warehouse }

what is sas enterprise intelligence architecture? : Sas-bi

1031

Explain what is the difference between olap and datawarehosue?

1150

You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?

984

Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

2288

What is star schema and snowflake schema?

1061

Mention the difference between ceil and floor functions in sas?

1216

What is blocking transformation?

1193

During the running session, output files are created by informatica server. Enlist few of them.

1028

In ARRAY processing, what does the DIM function do?

1233

Explain what are non-additive facts?

1078

What is informatica metadata and where is it stored?

1053

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1933

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

2200

What is catalog and types of catalogs in cagonos and which is better?

1094

Explain by-group processing?

1040

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