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

Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,

How can you differentiate between powercenter and power map?

0 Answers  

Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y

2 Answers   Amazon,

When do you use sql override in a lookup transformation?

0 Answers  

in oracle write query yourname+1 from dual

5 Answers  

wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,

Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,

What are ETL Tools?

0 Answers   Informatica,

Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers   IBM,

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,

What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?

2 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories