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 |
How the informatica server increases the session performance through partitioning the source?
What is complex mapping?
Explain about Recovering sessions?
If you want to create indexes after the load process which transformation you choose?
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
What do you mean by worklet?
Define filter transformation?
differences between service based and product based?
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?
what transformations are used for Variable port?