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 informatica powercenter repository?

1204

---

How to do the error handling of if ur source is flatfiles?

1968

---

What are the advantages of using informatica as an etl tool over teradata?

1023

---

How will the document be delivered to me?

1085

---

During the running session, output files are created by informatica server. Enlist few of them.

982

---

What is sq transformation?

1163

---

What do you understand by term role-playing dimension?

1048

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1080

---

Clarify the utilization of aggregator cache record?

1004

---

What is domain in terms of informatica?

1009

---

What is an Integration service in Informatica?

1136

---

Explain the aggregator transformation?

1169

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2365

---

What is fact table? Explain the different kinds of facts.

1079

---

what is the size of u r source(like file or table)?

2272

---