how to we create datamart?
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 |
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
What are the settings that you use to configure the joiner transformation?
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
What are the Differences between static cache and dynamic cache?
How does the session recovery work.
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
What is domain in terms of informatica?
where is the reject loader .
What is data transformation manager process?
How many repositories can we create in Informatica?
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.