what is datamart

Answers were Sorted based on User's Feedback



what is datamart..

Answer / sunil

Data Mart is subset of enterprise datawarehouse which
supports bussiness needs of middle level management in an
enterprise.

datamart is designed for particular line of business,such
as sales,marketing and finance
DW is maitaining the total organization of data
where as DM is maitained only particular subject.

Is This Answer Correct ?    12 Yes 0 No

what is datamart..

Answer / sujana

data mart is a particularsubject unlike dwh..for ex
totla organization data --dwh
sales,marketing etc--data mart

Is This Answer Correct ?    3 Yes 0 No

what is datamart..

Answer / tom

Adding to Sunil's answer- Data Mart is a object oriented and
DW is a subject oriented

Is This Answer Correct ?    2 Yes 0 No

what is datamart..

Answer / vali

hi guys iam adding one more point...
data mart is designed for business transcational process
where as dwh desgined for business analysys

any modifications plz let me kw..vali
vali413@gmail.com

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Informatica Interview Questions

what is shared lookup&persistent lookup?

4 Answers   Accenture, Cap Gemini,


Describe two levels in which update strategy transformation sets?

1 Answers  


Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,


Separate from an archive server and a powerhouse?

0 Answers  


What do you mean by filter transformation?

0 Answers  






In a table, 4 person having same salary. How to get Third person record only?

15 Answers  


Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  


What is meant by target load plan?

0 Answers  


if i have a delimited file as source so how can we seperate this file into three diff targets?

2 Answers   TCS,


In warehouses how many schemas are there?

0 Answers  


Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

0 Answers  


Categories