what is the architecture of any Data warehousing project?
Answer Posted / rekha
PROJECT PLANNING
REQUIREMENTS GATHERING ---PRODUCT SELECTION AND INSTALLTION
DIMESIONAL MODELING --- PHYSICAL
MODELING ---- DEPLOYMENT --- MAINTENANCE
IN EASY TREMS FOR DIMENSIONAL MODELING
1. SELECT THE BUSINEE PROCESS
2 IDENTIFY THE GRANINS
3 . DESIGN THE DIMENSION TABLE
4 . DESIGN THE FACT TABLE
ONCE THESE 4 STPE ARE OVER IT WILL MOVE TO PHYSICAL
MODELING
IN PHYSICAL MODELING U APPLY THE ETL PROCESS AND
PERFORMANCE TECHNOQUES .
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How union transformation is used?
How many numbers of sessions can one group in batches?
how to create user defined function (udf) in informatica
What are the restrictions of union transformation?
What is Session and Batches?
What is pmcmd command?
What is source qualifier transformation in informatica?
Enlist the advantages of informatica.
complex mapping ur project u r invlve can u explain and give real time example give me ?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What does update strategy mean, and what are the different option of it?
What is fact table? Explain the different kinds of facts.
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
difference between repository database and repository service?