How can i explain my project architecture in interview..? in
Igate asked me tell me your project flow from source to
target..?
- 1 Answers
- 21313 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 |
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
How is Data Models Used in Practice?
Can we use the mapping parameters or variables created in one mapping into another mapping?
tell me the rules and responsblites in our project(my project is development)
diffrence between command task and control task
why we use datawarehouse
How will you combine 3 different sources with a single source?
How many types of sessions are there in informatica.please explain them?
I have a flat file, want to reverse the contents of the flat file
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
How do you migrate data from one environment to another?
Teradata 
