Interested to Buy Any Domain ? << Click Here >> for more details...
what is the architecture of any Data warehousing project?
- 5 Answers
- 20791 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
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is informatica metadata and where is it stored?
What are the tasks that can be performed using sq?
what is mean by complex business rule ?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is the difference between writing a joiner query in ANSI style and THETA style?
How can you validate all mappings in the repository simultaneously?
What are Dimensional table?
What is option by which we can run all the sessions in a batch simultaneously?
What is meant by incremental aggregation?
what is song in infrmatica...?
Which development components of informatica have the highest usage?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
lookup transformation with screenshots
can anyone explain me about retail domain project in informatica?
