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?

501

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?

469

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

530

How to test report in reportnet?

545

What are aggregate transformation?

555

Tell me what is degree of a relation?

500

How to create prompts in report net?

534

What is the difference between power center and power mart?

532

What is the difference between filter and lookup transformation?

585

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

510

In document how to create metrics?

537

Is union transormation is active transformation?

563

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

622

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

487

What is edw?

602


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

How can you implement many relations in star schema model?

515


Explain is olap databases are called decision support system true/false?

530


What is the main difference between inmon and kimball philosophies of data warehousing?

631


What is meant by metadata in context of a data warehouse and how it is important?

637


How we are using this function?

579






What is the difference between constraind base load ordering and target load plan?

621


Explain what is data validation strategies for data mart validation after loading process?

574


what are different storage options supported by oracle ?

1584


How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?

534


What are the stages that are required in data warehousing?

492


What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

552


What is vdl (view definition language) explain?

604


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

5444


How to add a number to a macro variable?

529


What is the goal of optimizer?

570