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

Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,


What is primary and backup node?

0 Answers  


can u apply SCD2 on flat file tgt? if yes wat is the procedure?

3 Answers   Deloitte,


What is status code in informatica?

0 Answers  


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

4 Answers   Bank Of America,






Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

0 Answers   Cap Gemini,


hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,


What is power center repository?

1 Answers  


What are Dimensions and various types of Dimensions?

3 Answers   PayPal, TCS,


what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,


What do you mean by enterprise data warehousing?

0 Answers  


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 .

1 Answers  


Categories