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 model and how to test model?

1080

What is cognos connection?

1354

Which lifecycle we will use for reporting?

1023

How create measures and dimensions?

1138

How to generate cubes in cognos?

1022

What is the difference between the standard and metrics folder?

1021

What is the difference between a data mart and a data warehouse?

1094

What is the difference between the content store and content manager?

1092

What are the types of hierarchies?

1080

What is dtm?

1220

WHat all joins are there in Source Qualifier?

1 2647

What all join we can perform in LOOKUP transformation?

1025

Difference between Target-based loading and constraint-based loading?

1046

Ist the schema that a data warehouse system can implements.

999

What is the very basic difference between data warehouse and operational databases?

1033

Un-Answered Questions { Data Warehouse }

what is the effect of the options statement errors=1? : Sas programming

1109

What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?

2195

Explain transaction control transformation in informatica

1312

Can we access the compute node of Redshift directly ?

How can one identify whether mapping is correct or not without connecting session?

1498

what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

1082

What is the use of stop statement?

1123

What are the different types of parallelism used in abinitio?

1157

Explain what is etl process? How many steps etl contains explain with example?

939

What are the things to be considered while creating secondary index?

1150

What is the difference between datawarehouse and bi?

1007

How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

1107

What is application.cfm?

1116

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2061

What is factor analysis?

1201

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