1. Categories >> Software >> Data Warehouse >> Data Warehouse General
  2. Suggest New Category

Explain what are the modules in power mart?

Question Posted / rakesh


Explain what are the modules in power mart?..

Answer / Sandeep Kumar Bharti

Power Mart is a data warehousing tool from IBM. It consists of several modules, including: Data Architect, which is used for designing and building the data warehouse structure; Data Stage, which is used for loading and transforming data into the data warehouse; Data Navigator, which provides a user-friendly interface for managing and monitoring the data warehouse; and Data Server, which provides access to the data warehouse using SQL or OLAP interfaces.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1 Answers  

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

1 Answers  

How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

1 Answers  

Explain Association algorithm in Data mining?

1 Answers  

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

1 Answers  

Explain the main differences between star and snowflake schema?

1 Answers  

Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

1 Answers  

Define Data Warehousing?

1 Answers   Wipro,

Hi Guys, I have been to L& T last week ..Please find the questions mentioned below 1)Slowly changing dimension types 2)DML statement 3)DDL statement 4)write a syntax to create database 5) differences between count(*) and count(column) 6) differences between union and union all 7) what is decode 8) what is NVL 9) Arrange the values in ascending order 10,5,20,15,null 10)Primary and surrogate key 11)what is group by clause does? 12)what is difference between truncate and delete 13)what is difference between OLAP and OLTP ? 14)Architecture of Datawarehouse 15)how do you test the data validation from source as (flat file and xml) to staging tables. 16)what is shedule and time bound the mentioned above question asked in two rounds.all the best

2 Answers   L&T,

Explain where do we use semi and non additive facts?

1 Answers  

How are the dimension tables designed?

1 Answers  

Explain clustering algorithm?

1 Answers  

For more Data Warehouse General Interview Questions Click Here
Categories