how to we create datamart?
- 2 Answers
- 7001 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 |
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How can we eliminate duplicate rows from flatfile,explain?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Explain target update override in informatica
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.
What are the different versions of informatica?
What is meta data and system catalog?
How to delete the data in the target table after loaded.
What is difference between maplet and reusable transformation?
What the difference is between a database, a data warehouse and a data mart?
what is shared Cache. when we will use shared Cache?
how to sort date field in infomatica?
Teradata 
