how to we create datamart?

Answer Posted / amedela chandra sekhar

Data mart is a subset of Data warehouse.it is a complete information about one particular domain.eg:(finance,sales).

Data marts and Data warehouses are built on dimensional
data modeling where the relationship b/w dimension tables fact tables.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between a repository server and a powerhouse?

801


What is a transaction control transformation?

761


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1465


list out all the transformations which use cache?

683


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1928






What is rank index in rank transformation?

599


What will be the approach?

575


Which is the t/r that builts only single cache memory?

706


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

617


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

611


How to use procedural logic inside infromatica?

629


How many ways are there to do 'remove duplicate records in informatica'?

581


How to call shell scripts from informatica?

570


Can you generate sequence numbers without using the sequence generator transformation?

595


Briefly describe lookup transformation?

596