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 |
Explain pushdown optimization $pushdownconfig parameter - informatica
What is primary and backup node?
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
What is status code in informatica?
write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
hw cn v elimate dublicate values from lookup without overriding sql?
What is power center repository?
What are Dimensions and various types of Dimensions?
what is worklet and what use of worklet and in which situation we can use it?
What do you mean by enterprise data warehousing?
What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .