Data Warehouse General Interview Questions
Questions Answers Views Company eMail

Suppose we want to display zero when null values coming to report how can we do that?

526

Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?

486

Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

553

How to test report in reportnet?

563

What are aggregate transformation?

572

Tell me what is degree of a relation?

518

How to create prompts in report net?

553

What is the difference between power center and power mart?

553

What is the difference between filter and lookup transformation?

610

Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

528

In document how to create metrics?

553

Is union transormation is active transformation?

585

How to join 3 database like flat file, oracle, db2 in informatrica?

644

How to import vsam files from source to target. Do we need a special plugin?

507

What is edw?

623


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is pre-emptive and non-pre-emptive?

558


does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

5466


How can we acheive correlated sub-query in designer?can anyone help me in this regard?

487


What is the difference between power center and power mart?

553


The same tier?

540






What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?

566


Explain are data mart and dwh normalized or denormalized? Do both of them exist in

589


Why facts table is useful in representing the data?

496


Explain what is the difference between datawarehouse and bi?

525


Where we use surrogate key explain with example?

576


How to export mappings to the production environment?

502


Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?

582


Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

600


How to calculate fact table granularity?

573


Explain datawarehousing?

551