Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 the scenario which compels informatica server to reject files?

0 Answers  

what are the difference between Informatica 7.1 and 8.1?

6 Answers  

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?

7 Answers   Accenture,

What is powercenter on grid?

0 Answers  

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

0 Answers  

What are the types of lookup transformation?

0 Answers   Informatica,

how to run the batch using pmcmd command

2 Answers   Wipro,

what is polling?

1 Answers   Informatica,

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 Answers  

What is limitations of truncate and load option

1 Answers   Cap Gemini,

For more Informatica Interview Questions Click Here
Categories