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

I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?

1158

Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?

1130

What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?

1036

When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?

1152

What is local and formal parameter?

1402

Why might you create a stored procedure with the with recompile option?

1131

What is the importance of eme in abinitio?

1135

Where $mpjret is used in ab-initio?

1146

What is a cursor? Within a cursor, how would you update fields on the row just fetched?

1184

What is brodcasting and replicate?

1210

Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?

1098

What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?

1100

What are differences between different versions of co-op?

1209

Explain difference between onrow and onread method?

915

I generated one report design time I can color green. At run I want bule how to change dynamically? And which method I can over write?

986

Un-Answered Questions { Data Warehouse }

what is smart metrics in microstrategy?

1034

Enlist various types of routines in datastage.

1257

Briefly explain input and put function?

1085

what is proc Index? and what is proc document?

2723

What is the commit type if you have a transaction control transformation in the mapping?

1031

What do you mean by teradata intelliflex?

1107

Why do you use Mapping Parameter and mapping variable?

1766

define drill through?

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1900

How to load data in informatica ?

1023

Is there a difference between view filter and report filter?

921

Why is chameleon method used in data warehouse?

1167

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2037

How many input parameters can exist in an unconnected lookup?

1546

What Amazon redshift built for ?

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