how to answer the question "explain project architecture" in
informatica
pls any one who has the answer pls send the answer to this
mail id
"karumanchisrinu@gmail.com
Answers were Sorted based on User's Feedback
Answer / makkenasrinu
Architecture
1. Source systems: like mainframe,oracle,people soft,db2.
2. Landing tables: these are tables act like source. Used
For easy to access, for backup purpose, as reusable for
Other mappings.
3. Staging tables: from landing tables we extract the data
Into staging tables after all validations done on the data.
4. Dimension/facts: these are the tables those are used for analysis and make decisions by analyzing the data.
5. Aggregation tables: these tables have summarized data
Useful for managers who wants to view monthly wise sales,year wise sales etc.
6. Reporting layer: 4 and 5 phases are useful for reporting developers to generate reports. I hope this answer helps you.
Is This Answer Correct ? | 12 Yes | 1 No |
Answer / asdf
Source systems: like mainframe,oracle,people soft,db2.
2. Landing tables: these are tables act like source. Used
For easy to access, for backup purpose, as reusable for
Other mappings.
3. Staging tables: from landing tables we extract the data
Into staging tables after all validations done on the data.
4. Dimension/facts: these are the tables those are used for analysis and make decisions by analyzing the data.
5. Aggregation tables: these tables have summarized data
Useful for managers who wants to view monthly wise sales,year wise sales etc.
6. Reporting layer: 4 and 5 phases are useful for reporting developers to generate reports. I hope this answer helps you.
Is This Answer Correct ? | 0 Yes | 0 No |
what happens if the info.server doesn't find the session parameter in the parameter file?
What is the difference between Data Warehousing and Data Mining?
Explain do we need an etl tool? When do we go for the tools in the market?
Difference between flat files and relational sources?
Difference between flat files and relational sources?
How many types of transformations supported by sorted input?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.
Do we need an ETL tool? When do we go for the tools in the market?
How to know informatica conslole password??
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
how do u set partition points in the mapping?