Interested to Buy Any Domain ? << Click Here >> for more details...
How can i explain my project architecture in interview..? in
Igate asked me tell me your project flow from source to
target..?
- 1 Answers
- 22167 Views
- Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is the difference between informatica 7.0 and 8.0?
Design time, run time. If you don't create parameter what will happen
What differs when we choose the sorted input for aggregator transformation?
According to his methodology what all you need before you build a datawarehouse
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Explain what are the different versions of informatica?
What are the different ways to implement parallel processing in informatica?
What are the transformations that are not supported in mapplet?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
how to create user defined function (udf) in informatica
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Write the unconnected lookup syntax and how to return more than one column.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is a standalone command task?
