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
- 21992 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
What do you mean by channel change?
Tell me about Propagate functions in informatica
What is target designer and target load order?
What is the function of union transformation?
what is SDLC way of code development?
What are the types of schemas we have in data warehouse.
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How to create or import flat file definition in to the warehouse designer?
What is deployment group?
Performance tuning( what you did in performance tuning)
How many number of sessions can one group in batches?
How can informatica be used for an organization?
What are the tuning techniques you applied during your last project
How to generate sequence numbers using expression transformation?
What is a passive transformation?
