how to we create datamart?

Answers were Sorted based on User's Feedback



how to we create datamart?..

Answer / vaibhav bhandeo

Datamart is a subset of data warehouse and it supports a
particular region, business unit or business function.
Data warehouses and data marts are built on dimensional
data modeling where fact tables are connected with
dimension tables. It is designed for a particular line of
business, such as sales, marketing, or finance.

Is This Answer Correct ?    9 Yes 1 No

how to we create datamart?..

Answer / 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

More Informatica Interview Questions

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,


What are the settings that you use to configure the joiner transformation?

1 Answers   Informatica,


Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?

1 Answers  


What are the Differences between static cache and dynamic cache?

1 Answers  


How does the session recovery work.

1 Answers  


How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  


What is domain in terms of informatica?

1 Answers  


where is the reject loader .

1 Answers  


What is data transformation manager process?

1 Answers  


How many repositories can we create in Informatica?

3 Answers  


My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1 Answers  


Categories