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 is meant by drill through?(Mascot)

1 Answers  


how do u handle performance issues in Informatica . where can u monitor the performance ?

0 Answers  


Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com

1 Answers  


How to Check the source record count from traget table.

5 Answers   IBM,


what is the use of server manager?

0 Answers  






What are the new features of informatica 9 version?

2 Answers  


what is the main role of FI on business

0 Answers  


Difference between flat files and relational sources?

0 Answers  


what is the meant by Normalization and de-normalization?

2 Answers  


what are Lookup caches options? Including persistent caches.

0 Answers  


Explain do we need an etl tool?

0 Answers  


I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way

2 Answers  


Categories