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 prompts in report net?

1001

What is the difference between power center and power mart?

1049

What is the difference between filter and lookup transformation?

1120

Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

970

In document how to create metrics?

1006

Is union transormation is active transformation?

992

How to join 3 database like flat file, oracle, db2 in informatrica?

1258

How to import vsam files from source to target. Do we need a special plugin?

947

What is edw?

1207

Code the tables statement to produce a multi-level frequency?

1024

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1087

why use references rather than pointers in the public api, particularly for arguments which are modified?

1020

What is stored procedure in teradata?

1044

What is data transformation manager process?

1173

How do you change a non-reusable transformation to reusable transformation?

1010

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

1085

How to join multiple db in catalog?

1029

Differentiate between a database and data warehouse?

1156

what is chore commit property?

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2317

What is the difference between datawarehouse and bi?

973

What is the difference between constraind base load ordering and target load plan?

1127

What is target designer and target load order?

1122

How the users created differs from rpd/answers/dashboards level?

823

what is use of SDR function?

5187

what are the features in cognos8ui

2070

what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

2201

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1170

what is guided navigation?

916

How to select multiple values from type-in prompt?

1070

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