Answer Posted / maruzthi

IN BRIEF MAIN DIFFERENCES ARE
1.)PUSHDOWN OPTIMIZATION
(HERE YOU CAN PUSH TRANS LOGIC TO BE DONE IN THE SOURCE
OR TARGET DATABASE,SO THAT WE CAN PREVENT THE DATA TO CAME
OUT OF THE D.B LOGS)
2.)USER DEFINED FUNCTIONS LIKE
I.)REGULAR EXPRESSION.
II.)FINANCIAL.
III.)ENCODING
SUCH FN ARE OF TWO TYPES
1.)PRIVATE-ONLY CALLABLE FROM OTHER USER-DEFINDED FN
2.)PUBLIC-CALLABLE FROM ANY OTHER TRANSFORMATIONS FN.
F.F ENHANCEMENTS-OPTIONS FOR MERGING TARGETT PARTIONS
3.)IMP-INF-8 IS A SUBJECT -
ORIE`````````````````````````````````````````````````````1

Is it possible to create multiple domains on a single Informatica server?

1289

---

Scheduling properties,whats the default (sequential)

2011

---

Difference between Data and Index Caches?

1202

---

What do you mean by worklet?

1115

---

Explain what are the different types of transformation available in informatica.

1248

---

How do you change a non-reusable transformation to reusable transformation?

1046

---

What is the difference between source qualifier transformations source filter to filter transformation?

1096

---

What are the main features of Oracle 8i with context to datawarehouse?

2160

---

What all are steps in up gradation of Informatica server?

1094

---

What is informatica etl tool?

1060

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1956

---

What is aggregator transformation in informatica?

1004

---

What is meant by lookup transformation?

1181

---

What are mapplets? How is it different from a Reusable Transformation?

1136

---

What is informatica powercenter repository?

1256

---