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



how to answer the question "explain project architecture" in informatica pls any one w..

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

how to answer the question "explain project architecture" in informatica pls any one w..

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

Post New Answer

More ETL Interview Questions

what happens if the info.server doesn't find the session parameter in the parameter file?

1 Answers  


What is the difference between Data Warehousing and Data Mining?

0 Answers  


Explain do we need an etl tool? When do we go for the tools in the market?

0 Answers  


Difference between flat files and relational sources?

0 Answers  


Difference between flat files and relational sources?

2 Answers  


How many types of transformations supported by sorted input?

0 Answers  


can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

0 Answers  


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.

2 Answers   IBM, Tech Mahindra,


Do we need an ETL tool? When do we go for the tools in the market?

0 Answers  


How to know informatica conslole password??

0 Answers  


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.

0 Answers  


how do u set partition points in the mapping?

0 Answers   Quintiles,


Categories