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
my source is junk data how will u remove that junk data by using unix please any one replay me
Define filter transformation?
What is a snowflake schema?
What are connected or unconnected transformations?
How do you convert single row from source into three rows into target?
What do you understand by a term domain?
What are the tasks that source qualifier perform?
Different sorts of metadata that stores in the storage facility?
What is the difference between router and filter?
What are the various types of transformation?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is workflow monitor?
Can anyone tell me the new features in Informatica 9 Version?
Explain the different kinds of facts.