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

How to Create a folder using pmrep command?

1182

What happens when a session fails and you click on recover?

1123

Define Pmrep command?

1072

Is it possible to use a client with different version than that of its Informatica server?

1154

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1078

What is the difference between STOP and ABORT options in Workflow Monitor?

1263

While migrating the data from one environment to another environment how would you manage the connections?

1095

What all are steps in up gradation of Informatica server?

1047

What is a difference between complete, stop and abort?

1094

What does “tail –f” command do and what is its use as an Informatica admin.

1115

How do you manage the Parameter files while migrating your data from one environment to another environment?

1037

What could be the possible resons of locks by user?

1098

What is domain and gateway node?

1173

What do mean by local and global repository?

1232

How do you take back up of repository?

1162

Un-Answered Questions { Data Warehouse }

What are SAS/ACCESS and SAS/CONNECT?

1152

What is informatica metadata and where is it stored?

998

----------------------What are the User Securities?

1860

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1392

What are the steps involved in creating dimensional modeling process?

1026

Differentiate between sas functions and sas procedures.

1249

What is the difference between data warehouse and operational systems?

1149

What is lookup change?

1057

What is standalone command task?

1319

Can you explain the process of calendar?

1118

What is an i-server? What are the different modes to run it?

981

why is sas data integration studio important? : Sas-di

1045

What is aggregator transformation in informatica?

960

tell me the rules and responsblites in our project(my project is development)

1938

What is the difference between stop and abort in informatica

1101

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