Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Explain what are the different versions of informatica?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Could you explain what is enterprise data warehouse?
Why union transformation is an active transformation?
What are batches?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Describe the impact of several join conditions and join order in a joiner transformation?
How to load the data from people soft hrm to people soft erm using informatica?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
what is Active lock explain
Explain the etl program with few examples.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is the session task and command task?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
