Answer Posted / 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.

Write the unconnected lookup syntax and how to return more than one column.

1049

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2063

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2179

---

What are the popular informatica products?

958

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2266

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6039

---

What is joiner transformation in informatica?

993

---

what is $$$$?

2097

---

How you can differentiate between connected lookup and unconnected lookup?

1006

---

Define Pmrep command?

996

---

What is the meaning of decode in informatica?

1073

---

how to load rows into fact table in data warehouse

1114

---

How to do the error handling of if ur source is flatfiles?

1911

---

Explain the code page compatibility?

1021

---

How to create a non-reusable instance of reusable transformations?

1058

---