what is the use of Data Mart?
Answers were Sorted based on User's Feedback
Answer / amedela chandra sekhar
Data mart is a subset of data ware housing.it is a complete
information about one particular domain.
ex:finance,hr,sales.....
chandumba2005@gmail.com
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / nagendra phani
Data Mart is the subset of datawahehouse and it is used to
store the data department wise.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sivaram
A DATA MART IS A SUB-SET OF AN ENTERPRRISE DATAWAREHOUSING.
A DATA MART IS ASUBJECT ORIENTED DATA BASE WHICH SUPPORTS THE
BUSINESS NEEDS OF INDIVIDUAL DEPARTMENTS WITHIN THE
ENTERPRISE.
A DATA MART IS ALSO KNOWN AS HIGH PERFORMENCE QUERY
STRUCTUERS.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / yash
data mart are specific ,repository of data, designed to
answer specific users.( examaple :sales)
| Is This Answer Correct ? | 0 Yes | 1 No |
Explain the features of connected and unconnected lookup.
can we use self join in informaitca?
How to handle changing source file counts in a mapping?
what are the limitation of sorter transformation?
how u know when to use a static cache and dynamic cache in lookup transformation.
what are factless facts? And in which scenario will you use such kinds of fact tables.
What are the types of maping wizards that r to be provided in Informatica?
what is the method of error handling when session is running?
what is difference between dimention table and fact table?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What are the types of caches in lookup? Explain them.
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?