Interested to Buy Any Domain ? << Click Here >> for more details...
how to we create datamart?
- 2 Answers
- 8407 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 |
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
without dynamic lookup how to insert new rows and update existing rows?
Can you start a batches with in a batch?
What is the sql query overwrite in source qualifier in informatica
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
What is the cumulative sum and moving sum?
What is the difference between view and materialised view?
How to extract the informatica rejected data?
What are the new features of informatica 7.1?
what is datamart
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
Teradata 
