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
- 22094 Views
- Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro, I also Faced
- E-Mail Answers
Answer / 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 |
Where should yoU place the flat file to import the flat file defintion to the designer?
In dimension and fact table? which one holds big data?
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
Why use the lookup transformation ?
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Explain reference cursor?
Could any one to tell Fact table Partitioning?
What is different between the data warehouse and data mart?
difference between top down(w.h inmon)and bottom up(ralph kimball)approach?
How mapping parameter and variable works
What is the command used to run a batch?
Teradata 
