How can i explain my project architecture in interview..? in
Igate asked me tell me your project flow from source to
target..?



How can i explain my project architecture in interview..? in Igate asked me tell me your project fl..

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

Post New Answer

More Informatica Interview Questions

What does command task mean?

0 Answers  


Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,


what is junk dimension

4 Answers   Cap Gemini,


Why filter transformation is an active one?

0 Answers  


what is SDLC way of code development?

0 Answers  


What is source qualifier transformation in informatica?

0 Answers  


Can we create out put ports in source qualifier t/r?

5 Answers   TCS,


My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,


WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

2 Answers   TCS,


how will you remove the duplicate records from flat file without using sorter?

7 Answers  


If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.

3 Answers   IBM, TCS,


what is shared Cache. when we will use shared Cache?

4 Answers  


Categories