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
- 22074 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 |
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
What is workflow? What are the components of workflow manager?
What is a parameter When and where do you them when does the value will be created
Explain the aggregator transformation?
How to delete first 3 rows & last 3 rows in target table in informatica
How mapping parameter and variable works
where does the default group roew in a router is stored what is the default size of memory in router
How do you take care of security using a repository manager
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
when will we go for unconnected lookup transformation in Informatica?
How can yoU create or import flat file definition in to the warehouse designer?
Teradata 
