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.

What is meant by target load plan?

914

---

Define joiner transformation?

986

---

Explain the pipeline partition with real time example?

1083

---

what is SDLC way of code development?

1967

---

Enlist some properties of sessions.

1020

---

Explain the shared cache and re-cache?

1049

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2237

---

What is a dimensional model?

926

---

What is source qualifier transformation in informatica?

946

---

Mention a few design and development best practices for informatica?

933

---

What is dimensional table?

1002

---

How to Create a folder using pmrep command?

1104

---

What are the settings that you use to configure the joiner transformation?

1000

---

To import the flat file definition into the designer where should the flat file be placed?

1004

---

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

2688

---