what is datamart
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
what is shared lookup&persistent lookup?
4 Answers Accenture, Cap Gemini,
Describe two levels in which update strategy transformation sets?
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?
Separate from an archive server and a powerhouse?
What do you mean by filter transformation?
In a table, 4 person having same salary. How to get Third person record only?
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
What is meant by target load plan?
if i have a delimited file as source so how can we seperate this file into three diff targets?
In warehouses how many schemas are there?
Normalizer transformation is not involved in Mapplet.. why???
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