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?

1230

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

1185

Define Pmrep command?

1120

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

1198

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?

1327

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

1134

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?

1071

What could be the possible resons of locks by user?

1150

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 }

if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

1126

how to perform single sign in cognos by using url?

1207

Which transformation we use to convert 'NA' to 'Not Available'

1319

explain what is factor analysis? : Sas-administrator

1178

What is the precedence of stage variables,derivations, and constraints?

1133

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

3026

Explain what transformation and how many are there in informatica?

1036

Explain what are conformed dimensions?

1151

How to do the error handling of if ur source is flatfiles?

2026

What is PDV?

1210

How we can scale Reshift database?

Can I deploy a single bi application in multiple languages?

1030

What are the different versions of informatica?

1343

What is crass reference table?

1100

What is a conditional attribute in microstrategy?

1157

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