Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 18035 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the ETL Testing Operations?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
how do u really know that paging to disk is happening while u are using a lookup transform?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
Explain what are the various etl tools in the market?
what is the difference between cardinality and Nullability?
how do u set partition points in the mapping?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
how does the server recongnise the source and target databases.Elaborate on this
how to connect to a flatfile through ftp in informatica
What is data modeling and data mining?
Identifying the bottlenecks in various components of Informatica and resolving them.
What is staging area referring to?
