Interested to Buy Any Domain ? << Click Here >> for more details...
what is the architecture of any Data warehousing project?
- 5 Answers
- 20611 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
How you know when to use a static cache and dynamic cache in lookup transformation?
Explain the etl program with few examples.
Differentiate between joiner and lookup transformation?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
what is the hint? how to use it to reduce the query processing in program?
How to update or delete the rows in a target, which do not have key fields?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are data-driven sessions?
How can we store previous session logs?
Explian the Process of deployment groups in informatica
What is informatica metadata and where is it stored?
What are the different clients of powercenter?
Differentiate between a repository server and a powerhouse?
