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.

complex mapping ur project u r invlve can u explain and give real time example give me ?

1836

---

What is an aggregator transformation?

613

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

611

---

How to join three sources using joiner?

569

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

769

---

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1931

---

Tell me about MD5 functions in informatica

519

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

3505

---

What is a difference between complete, stop and abort?

637

---

design of staging area?

1585

---

how to load rows into fact table in data warehouse

637

---

Explain the scenario which compels informatica server to reject files?

654

---

What is the difference between a connected look up and unconnected lookup?

566

---

Differentiate between reusable transformation and mapplet.

568

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

598

---