Interested to Buy Any Domain ? << Click Here >> for more details...
How can i explain my project architecture in interview..? in
Igate asked me tell me your project flow from source to
target..?
- 1 Answers
- 22071 Views
- Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / manojdubba
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
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 ? | 55 Yes | 2 No |
Post New Answer View All Answers
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
what is index?how it can work in informatica
How do you handle two sessions in Informatica
As union transformation gives UNION ALL output, how you will get the UNION output?
How many ways are there to do 'remove duplicate records in informatica'?
How many types of sessions are there in informatica.please explain them?
What is update strategy transform?
What is domain in terms of informatica?
What is pmcmd command?
What is a transaction control transformation?
How we can create indexes after completing the loan process?
Implementation methodology
What are the new features of informatica 9.x in developer level?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How to extract sap data using informatica?
