what is the architecture of any Data warehousing project?
Answers were Sorted based on User's Feedback
Answer / veera reddy
Basically there are two types of architectures.
1. Top Down(Dependent) and 2. Bottom up(Independent)
In Top Down approach initially DW comes and then DM.
In Bottom Up approach intially DM comes and then DW.
Is This Answer Correct ? | 17 Yes | 1 No |
Answer / praveen kumar
step-01------>source to staging
step-02------>staging to dimension
step-03------>dimension to fact
This is the general procedure.........
Is This Answer Correct ? | 13 Yes | 0 No |
Answer / 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 |
Answer / bsgsr
i simply put this way.
source to staging
staging to dwh
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / kumarapillaietl@gmail.com
first we integrate data into source to staging tables, from staging we movie into work table at the data moment of stage to work we do all transformation logic , then from work table we load data into fact and dimention table using scd 2.
Is This Answer Correct ? | 0 Yes | 0 No |
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Write the program through which the records can be updated?
How to extract original records at one target & Duplicate records at one target?
Name 4 output files that informatica server creates during session running?
Design time, run time. If you don't create parameter what will happen
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
why dimenstion tables are denormalized in nature ?
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
How to load query faster,so that It will take less time to load?
Can yoU use the maping parameters or variables created in one maping into another maping?
What are some examples of informatica etl programs?
What are the different types of olap? Give an example?