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

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

1 Answers  


What is fact? What are the types of facts?

0 Answers  


where are the log files generally stored.Can you change the path of the file.what can the path be?

0 Answers  


Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

0 Answers  


can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

2 Answers  


how do u implement unconn.stored proc. in a mapping?

1 Answers  


what is Forward,Reverse and Re_engineering?

0 Answers  


what is the difference between shortcut of an object and copy of an object? compare them?

1 Answers  


how would u estimate the size of Lookup transform data and index cache?

1 Answers  


What is Relational Integrity?

1 Answers  


What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

0 Answers  


Do we need an etl tool?

0 Answers  


Categories