what is the architecture of any Data warehousing project?
- 5 Answers
- 21234 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 |
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga
In joiner, how to load Master table in Target?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
What are the different types of repositories created using informatica?
Explain why we use partitioning the session in informatica?
What is persistent lookup cache?
When to use normalization transformation other than cobol source?
What is data transformation manager process?
What does cheating measurement mean?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Why update strategy and union transformations are active?
Teradata 
