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

Explain the difference between filter and conditin?

1 1024

Explain how to export mappings to the production environment?

1 1042

Explain can report net connect multiple datasource at a time in report creation time?

1 1002

Explain the versions of reportnet?

1 1058

Explain what are the advantages of query studio compared to report studio?

1 1076

Explain what is the limit to the number of sources and targets you can have in a mapping?

1 1073

Explain what is the difference between powerplay transformer and power play reports?

1 1254

Explain what are the mapping paramaters and maping variables?

1 1168

Explain the differences between normalizer and normalizer transformation?

1 1138

Explain what are the various file formats involved in reportnet?

1 1058

Explain multivalued dependency?

1 1055

Explain functional dependency?

1 1157

Explain what are the tasks that loadmanger process will do?

1 1003

Explain what are the basic needs to join two sources in a source qualifier?

1 1257

Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?

1 1307

Un-Answered Questions { Data Warehouse }

What is aggregate table and aggregate fact table ... Any examples of both?

1118

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4796

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2767

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2493

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1202

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2342

Demonstrate experience in maintaining quality process standards?

2672

What is the purpose of Dataware Control?

1121

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1197

What are the data types present in bo? What happens if we implement view in the designer and report?

1082

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1849

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..

1963

how to generate the test data in sas without input data? : Sas-administrator

1202

Are you involved in writing the inferential analysis plan? Tables specifications?

4019

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2437

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