1. Categories >> Software >> Data Warehouse >> Data Warehouse General
  2. Suggest New Category
Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What are components of reportnet?

 606

Explain what is power center repository?

 564

How to export mappings to the production environment?

 510

What is vdl (view definition language) explain?

 648

What are necessary tasks to install reportnet software?

 518

How to generate iqd file from framework manager?

 529

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

 596

What is the extension of file to save template?

 580

Explain normalization?

 564

How to get the first 100 rows from the flat file into the target?

 685

Explain why dimenstion tables are denormalized in nature?

 518

Explain what are components of report studio?

 571

Explain what is metadata reporter?

 573

What are the advantages and disadvantages of reporting directly against the database?

 549

Explain what is difference between query studio and report studio?

 553

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

524

what type of raid setup would you put your tx logs?

530

Can a dimension table contain numeric values?

603

What is execution plan?

751

How to pivot row data using informatica?

521




Explain difference between view and materialized view?

509

how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

1728

Can we take backup when the database is opened?

595

Explain me what are data marts?

600

Explain what is a three tier data warehouse?

548

how much memory space occupied real time project (roughly)?

1807

How many types of facts and what are they?

555

Explain where do we use semi and non additive facts?

570

What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

570

What are the different types of join operations?

563

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