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

generate date / time dimension in informatica

1108

---

How to generate sequence numbers without using the sequence generator transformation?

1177

---

Explain your project of banking domian.

1639

---

What is lookup change?

1029

---

What are the static cache and dynamic cache in informatica?

1168

---

tell me the rules and responsblites in our project(my project is development)

1914

---

What is a difference between complete, stop and abort?

1067

---

What do you mean by filter transformation?

938

---

Explain the difference between mapping parameter and mapping variable?

1018

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1885

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1214

---

Difference between Data and Index Caches?

1123

---

Briefly define a session task?

1105

---

Describe expression transformation?

1110

---

In informatica workflow manager, how many repositories can be created?

1329

---