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

A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

1 Answers   TATA,

In which scenario did u used Mapping variable?

1 Answers   Cognizant,

What is a connected transformation?

1 Answers   Informatica,

How to use pmcmd utility command?

1 Answers  

What are reusable transformations in how many ways we can create them?

2 Answers  

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

3 Answers   CTS,

Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai

1 Answers   Infosys, Saksoft,

scenario

1 Answers  

following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

5 Answers   Wipro,

Can we create a node as a gateway node and the same node can be assigned to a grid?

1 Answers  

How can we update a record in the target table without using update strategy?

1 Answers  

How to send duplicates to one target and unique rows to one target?target is empty

9 Answers   Amazon, IBM, Wipro,

For more Informatica Interview Questions Click Here
Categories