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 are the differences between oltp and olap?
what is the -ve test case in your project.
State the limitations where we cannot use joiner in the mapping pipeline?
What's the layout of parameter file (what does a parameter file contain?)?
What are Dimensional table?
What is dimensional table? Explain the different dimensions.
How do you change a non-reusable transformation to reusable transformation?
how tokens will generate?
What is the fact table?
Explain the different lookup methods used in informatica?
How do you load alternate records into different tables through mapping flow?
What is a connected transformation?
How can you differentiate between powercenter and power map?
What is repository manager?
Write the different tools in the workflow manager?