hi
please someone exlplain the data flow in informatica architecture
Printable View
hi
please someone exlplain the data flow in informatica architecture
explain visual source safe
version control
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 .