Answer Posted / vaibhav bhandeo
Datamart is a subset of data warehouse and it supports a
particular region, business unit or business function.
Data warehouses and data marts are built on dimensional
data modeling where fact tables are connected with
dimension tables. It is designed for a particular line of
business, such as sales, marketing, or finance.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What is sorter transformation?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How to load a Dimension ? and how to load a fact table?
Scheduling properties,whats the default (sequential)
What is expression transformation?
Explain about Informatica server process that how it works relates to mapping variables?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is a sorter transformation?
Write the program through which the records can be updated?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Implementation methodology
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is meant by lookup transformation?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?