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?

541

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?

500

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

565

How to test report in reportnet?

574

What are aggregate transformation?

590

Tell me what is degree of a relation?

532

How to create prompts in report net?

563

What is the difference between power center and power mart?

566

What is the difference between filter and lookup transformation?

622

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

536

In document how to create metrics?

563

Is union transormation is active transformation?

596

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

657

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

519

What is edw?

633


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Is there any default username & pwd for bo designer & supervisor?

580


How to generate iqd file from framework manager?

531


What we will do with the universe for faster process?

581


Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

531


Define data warehouse?

559






What are the mapping paramaters and maping variables?

575


What is the difference between olap and datawarehosue?

514


Explain bus schema?

558


What is the difference between a primary and secondary actor in use case modeling?

592


what are the different views that are considered when building an object-oriented software system?

633


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

1812


What is vdl (view definition language) explain?

651


Explain swot analysis?

636


How we are using this function?

603


Explain the data type of the surrogate key?

575