Interested to Buy Any Domain ? << Click Here >> for more details...
what is the architecture of any Data warehousing project?
- 5 Answers
- 21109 Views
- IBM, I also Faced
- E-Mail Answers
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
Different circumstance which drives informatica server to expel records?
How to go to the older version for a mapping?
Explain joiner transformation in informatica
How can we delete duplicate rows from flat files?
What is a filter transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
What do you understand by SOA of Informatica?
Explain the informatica workflow?
Why update strategy and union transformations are active? Explain with examples.
What is native users?
Under which circumstances, informatica server creates reject files?
Write the unconnected lookup syntax and how to return more than one column.
In how many ways we can create ports?
What does refresh system mean, and what are its distinctive choice?
Design time, run time. If you don't create parameter what will happen
