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

What is Target Update Override? What is the Use ?

8 Answers   Patni,

How to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers   Cap Gemini,

plz plz plz send client names and project names in informatica?

1 Answers  

2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?

2 Answers   Emphasis,

Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....

2 Answers  




we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,

What is standalone command task?

0 Answers  

can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,

The question was on time stamp. what is the difference between HH and HH24 when to use when.

0 Answers   Nationwide,

What is update strategy transform?

0 Answers  

How we can confirm all mappings in the repository simultaneously?

1 Answers  

For more Informatica Interview Questions Click Here
Categories