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
- 22166 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 |
Useful UNIX commands regular/frequently used
Explain the different dimensions.
From where we can start or use pmcmd?
What happens if we dont select data driven option?
Tell me about Propagate functions in informatica
what is Partitioning ? where we can use Partition?
difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?
plz plz plz send client names and project names in informatica?
what are 3 tech challenges/ common issues you face?
What are the tasks that Loadmanger process will do?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
Teradata 
