- Forum
- Databases
- Data Warehousing - description of informatica power center 6 architecture
-
Junior Member
description of informatica power center 6 architecture
hi
please someone exlplain the data flow in informatica architecture
-
Junior Member
Re: description of informatica power center 6 architecture
explain visual source safe
version control
-
Junior Member
Re: description of informatica power center 6 architecture
i know the architecture of 7.1 tell me whether it is correct or not
Project architecture is like
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
phases 4 & 5 are very important because they are used fo the reports so it is helpful for the decision making .
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules