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

what is model and say about process how to create model and how to test model?

IBM,

1061

how you provide security to reports? How you provide security to packages ?

IBM,

1068

how to perform single sign in cognos by using url?

IBM,

1153

what is the difference between list report and crosstab report?

IBM,

1185

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

IBM,

1037

what are the special features in cognos reportnet?

IBM,

1060

what is log in cognos?

IBM,

1200

how you migrate reports to cognos 8 from previous versions?

IBM,

1042

what are slowly changing dimensions? Why we are used scd?

IBM,

1125

how to create cubes in transformer ?

IBM,

1073

what are the names of the reports that you prepared?

IBM,

1106

how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

IBM,

1065

how can I test reports in cagnos?

IBM,

1153

how to create measures and dimensions?

IBM,

1116

explain how to create powerplay reports?

IBM,

1016

Un-Answered Questions { Data Warehouse }

CHANGE CAPTURE

1299

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

4727

Is olap services sold as a separate product?

915

How you prepared reports for OLAP?

1595

What is the use of report studio?

1030

How to load last n records of file into target table - informatica

1081

What are the statements in proc sql?

1105

Differentiate between datastage and informatica?

1181

1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?

3567

how tokens will generate?

2204

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1995

Can you define merge?

1119

What are the conditions needed to improve the performance of informatica aggregator transformation?

1093

what is SAS OPTIMIZATION?

2295

Please let me know how to make Data masking in informatica..

1721

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