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,

651

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

IBM,

745

how to perform single sign in cognos by using url?

IBM,

648

what is the difference between list report and crosstab report?

IBM,

803

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

IBM,

656

what are the special features in cognos reportnet?

IBM,

711

what is log in cognos?

IBM,

743

how you migrate reports to cognos 8 from previous versions?

IBM,

712

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

IBM,

693

how to create cubes in transformer ?

IBM,

717

what are the names of the reports that you prepared?

IBM,

691

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

IBM,

685

how can I test reports in cagnos?

IBM,

736

how to create measures and dimensions?

IBM,

698

explain how to create powerplay reports?

IBM,

688


Un-Answered Questions { Data Warehouse }

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

735


Give me any example of semi and non additive measures?

644


Give some difference between oltp and olap.

674


What are the various indexes in teradata? How to use them?

650


Why is business intelligence (bi) important in data warehousing?

607






What are the different lookup cache(s)?

712


How to use consolidations in microstrategy report?

676


Explain what are fact, dimension, and measure?

638


Discuss the advantages of using partitioned primary index in a query?

616


What’s the difference between var b1 – b3 and var b1 — b3?

942


What are the difficulties u faced while doing vital signs table or dataset?

2038


What are roles and groups and benefits of using them?

656


How to load specific no.of records using bteq, or fastload,or multiload

1410


What is the purpose of having stored procedures in a data-based?

656


What is prompt types of prompts?use of prompts syntax of prompt?

757