Interested to Buy Any Domain ? << Click Here >> for more details...
what is datamart
- 4 Answers
- 8016 Views
- IBM, Informatica, I also Faced
- E-Mail Answers
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 meant by lookup transformation?
connected and unconnected lookups?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
what is curr val use for in sequence generator?
According to his methodology what all you need before you build a datawarehouse
what is the size of u r source(like file or table)?
can we override a native sql query within informatica? How do we do it?
If I have a index defined on target table and if set it to bulk load will it work ?
What are the measure objects?
How can we update a record in the target table without using update strategy?
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
Write the advantages of partitioning a session?
Teradata 
