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?

1234

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

1192

Define Pmrep command?

1128

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

1200

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?

1126

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

1332

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

1141

What all are steps in up gradation of Informatica server?

1099

What is a difference between complete, stop and abort?

1132

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

1150

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

1073

What could be the possible resons of locks by user?

1155

What is domain and gateway node?

1211

What do mean by local and global repository?

1286

How do you take back up of repository?

1212

Un-Answered Questions { Data Warehouse }

Enlist the tasks for which source qualifier transformation is used.

1085

What is the use of cognos decision stream?

1149

How you will check the version of teradata?

1235

What are the data marts?

1023

how to insert/update a csv file by comparing it with another csv file?

2640

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1154

Compare sas with other data analytics tools.

1112

Enlist the functions performed by sas.

1200

what are the steps to troubleshoot the feeders?

Do you view contain data?

1015

What is the purpose of having stored procedures in a database?

1234

what do you mean by passthrough functions?

1028

what is sas and what are the functions? : Sas-administrator

1037

what is the difference steps for data modeling?

2666

Explain attribute?

1044

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