Interested to Buy Any Domain ? << Click Here >> for more details...
what is the architecture of any Data warehousing project?
- 5 Answers
- 20920 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
design of staging area?
Which version configuration tool used in ur project?
What is the difference between stop and abort in informatica
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Implementation methodology
complex mapping ur project u r invlve can u explain and give real time example give me ?
How to partition the Session?
Explain the difference between a data warehouse and a data mart?
How can we create index after completion of load process?
What is a router transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
explain about unit testing? in real time?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is dimensional table? Explain the different dimensions.
