Answer / krish

One can push transformation logic to the source or target
database using pushdown optimization. The Integration
Service translates the transformation logic into SQL queries
and sends the SQL queries to the source or the target
database which executes the SQL queries to process the
transformations. The amount of transformation logic one can
push to the database depends on the database, transformation
logic, and mapping and session configuration. The
Integration Service analyzes the transformation logic it can
push to the database and executes the SQL statement
generated against the source or target tables, and it
processes any transformation logic that it cannot push to
the databas

there are some limitations to it like if we are using
variable port we can't do pushdown.

Answer / pradeep

Basically we use the push down optimization to reduce the load on the integration service.The integration service translate the business logic into sql query and it pushes to source & Target dbs.In this form we can reduce the load on integration.

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers   TCS,

---

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  

---

What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,

---

What is the use of incremental aggregation?

2 Answers  

---

Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

0 Answers   Puma,

---

Can you use flat files in Mapplets.

0 Answers  

---

What is the difference between view and materialised view?

4 Answers  

---

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,

---

What is joiner cache?

2 Answers   TCS,

---

which one is better either active or passive transformation in informatica

1 Answers  

---

In which transformation you cannot drag ports into it?

0 Answers   Informatica,

---