Answer / nagaraju

push down optimization is used increase the performance.in this concept integration service convert the transformation logic into query and send to the database.

Answer / akhil4

this option available in session(work flow) properties.
it increase informatica server performance.
when ever u enable this option it created view in database related to logic.(MEANS YOU TAKEN SEVERAL T/R IN THIS U HAVE IMPLEMENTED LOGIC USING THAT LOGIC IT WILL CREATE A VIEW)
U START WF IT TAKE THE DATA DIRECTLY TO SQ AND PUSH DATA THROUGH LOGIC AND LODES INTO TARGET.

scd methodology?

2 Answers  

---

Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?

1 Answers  

---

Describe two levels in which update strategy transformation sets?

1 Answers  

---

Why the UNION TRANSFERMATION is an Active TRANSFERMATION

6 Answers   Emphasis,

---

what are the types of Data warehousing ?

1 Answers  

---

how many tasks are there in informatica ?

15 Answers   DELL, iGate, TCS,

---

Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

2 Answers   Infotech,

---

Using Expression transformation how to remove duplicate records from a relational source?

4 Answers  

---

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.

3 Answers   Wipro,

---

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

3 Answers  

---

what are the types of facts with Examples?

3 Answers  

---

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  

---