Interested to Buy Any Domain ? << Click Here >> for more details...
what is the architecture of any Data warehousing project?
- 5 Answers
- 20810 Views
- IBM, I also Faced
- E-Mail Answers
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 |
Can I create one wrkflw which will run different wrkflws on schedule time?
What is native users?
in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
What is meta data and system catalog?
What are Rapid changing dimensions?
How to delete duplicate row using informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Why we select the table which has minimum number of records as Master table in joiner?
What is a repository manager?
I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Teradata 
