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.

When will you use SQL override in a lookup transformation?

1 Answers  

---

How do you change parameter when you move it from development to production.

1 Answers  

---

how remove 1st 3 records & last 3 records in informatics

4 Answers   TetraSoft,

---

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,

---

how can we perform incremental aggregation?explain with example?

9 Answers   IBM, TCS,

---

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

---

source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

4 Answers   Polaris,

---

What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,

---

Explain grouped cross tab?

1 Answers   Accenture,

---

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  

---

Explain your project of banking domian.

0 Answers   Cap Gemini,

---

how can you load data into target table without leading zeor's

4 Answers   Deloitte,

---