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.

Useful UNIX commands regular/frequently used

1 Answers   Deloitte,

---

tell me the push down optimization

2 Answers   Wipro,

---

i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 Answers  

---

Explain the informatica workflow?

0 Answers  

---

How to generate the HTML output using Informatica.

3 Answers   Wipro,

---

---

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 Answers  

---

Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,

---

What is hash partition?

1 Answers  

---

What are the parts of Informatica Server?

1 Answers   Cognizant,

---

Explain your project of banking domian.

0 Answers   Cap Gemini,

---

How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,

---

Three date formats are there . How to change these three into One format without using expression transformation ?

3 Answers   HP,

---