Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / manohar.jojo


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

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

0 Answers   Informatica,

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

What is junk dimention?

3 Answers   Patni,

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,

how u know when to use a static cache and dynamic cache in lookup transformation.

9 Answers   Accenture,

write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500

3 Answers   Accenture,

Mention some types of transformation?

0 Answers  

How to Create a folder using pmrep command?

0 Answers  

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

2 Answers   CTS,

what is unit testing?tell me proceedure

0 Answers   L&T, UST,

WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.

2 Answers  

For more Informatica Interview Questions Click Here
Categories