Interested to Buy Any Domain ? << Click Here >> for more details...
how to we create datamart?
- 2 Answers
- 8390 Views
- HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / amedela chandra sekhar
Data mart is a subset of Data warehouse.it is a complete information about one particular domain.eg:(finance,sales).
Data marts and Data warehouses are built on dimensional
data modeling where the relationship b/w dimension tables fact tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
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
What is confirmed dimension and fact?
What is log file,and where is it located,why u r using the log file
what is the diff b/w union and joiner and lookup?
Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500
What is event and what are the tasks related to it?
What is informatica? Why do we need it?
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
Mention a few design and development best practices for informatica?
Can anyone tell me the new features in Informatica 9 Version?
What is a connected transformation?
How can you define user defied event?
Teradata 
