Interested to Buy Any Domain ? << Click Here >> for more details...
how to we create datamart?
- 2 Answers
- 8403 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 |
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
Define mapping and session?
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
Do you have knowledge in ralph kimball methodology
can we override a native sql query within informatica? Where do we do it?
How will you update the row without using update statergy?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
Can you use flat files in Mapplets.
In ur current projectu have done any performance tuning of mappings?
What are reusable transformations in how many ways we can create them?
Quickly characterize reusable change?
what are the deliverables?in your project?
Teradata 
