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 repository in abinitio for stand alone system(local nt)?

1224

How do you convert 4-way mfs to 8-way mfs?

1 3327

What is m_dump?

1235

How can you force the optimizer to use a particular index?

1061

Describe the grant/revoke ddl facility and how it is implemented?

1149

When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?

1140

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

1152

What is the difference between a scan component and a rollup component?

1191

Explain the difference between the truncate and delete commands?

1167

Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?

1152

Can anyone give me an exaple of realtime start script in the graph?

1055

What is the difference between dml expression and xfr expression?

1094

How would you find out whether a sql query is using the indices you expect?

1070

What is $mpjret?

1152

How can I run the 2 gui merge files?

1179

Un-Answered Questions { Data Warehouse }

What are the mapping parameters and mapping variables?

1204

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

1215

What is substr function?

1194

Explain degenerate dimension table?

1047

Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?

1077

How to load the data from people soft hrm to people soft erm using informatica?

1020

What are the co> operating system’s assorted library of integrated components?

1118

Describe a time when you were really stuck on a problem and how you solved it?

2550

While creating table my dba has fallback or no fallback in his ddl. What is that?

1186

Explain amp in teradata?

1084

What are the scrubbing procedures in sas?

1008

what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

2500

Explain what is ods (operation data source)?

990

Can we create Hierarchies in generic datasources?

2384

Can you explain the performance and scalability of co> operating system?

1128

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