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

Explain what is the difference between stop and abort?

 549

What are components of report studio?

 538

What are the mapping paramaters and maping variables?

 571

What are the advantages of query studio compared to report studio?

 510

Explain what is the extension of file to save template?

 515

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

 562

Explain the difference between filter and conditin?

 568

Explain how to export mappings to the production environment?

 566

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

 499

Explain the versions of reportnet?

 555

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

 553

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

 550

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

 644

Explain what are the mapping paramaters and maping variables?

 567

Explain the differences between normalizer and normalizer transformation?

 521

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are the different types of segments?

550

If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

520

What is data analytics in simple terms?

555

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

524

What function should we use to display the value entered or selected by a user in response to a prompt?

516




Fact table is in normalized or de-normalized form?

544

What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

537

Explain what are the tasks that loadmanger process will do?

483

After we create a scd table, can we use that particular dimension as a dimension table for star schema?

553

What is a cube in data warehousing concept?

662

What is the difference between power center & power mart?

507

In a star schema, are foreign key constraints between facts and dimensions neccessary?

547

What are the data types present in bo?

574

How can we determine what records to extract?

599

What is aggregate fact table?

533

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