Answer / venubyna1

1. Source side push down
Integration service determine the T/r logic it ll send
as much as possible to source data base server

2.Target side push down
Integration service determine the T/r logic it ll send
as much as possible to targer data base server

3.fullside push down
Integration service determine the T/r logic it ll send
to source and target data base server

Answer / praveen hattikal

pushdown optimization: way of load balancing among the
servers to achieve optimal performance
Veteran ETL developers often come across issues when they
need to determine the appropriate place to perform ETL
logic. Suppose an ETL logic needs to filter out data based
on some condition. One can either do it in database by
using WHERE condition in the SQL query or inside
Informatica by using Informatica Filter transformation.
Sometimes, we can even "push" some transformation logic to
the target database instead of doing it in the source side
(Especially in the case of EL-T rather than ETL). Such
optimization is crucial for overall ETL performance.

Explain load alternative records / rows into multiple targets - informatica

0 Answers   Informatica,

---

WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

2 Answers   TCS,

---

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

How to improve the performance of Aggregate transformation?

3 Answers   Dmss,

---

if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,

---

---

What is informatica?

0 Answers  

---

There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

2 Answers   L&T,

---

What are the scheduling options to run a sesion?

2 Answers  

---

Whats the difference between $, $$, $$$

9 Answers  

---

Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,

---

Define mapping and session?

0 Answers   Informatica,

---

What does role playing dimension mean?

0 Answers  

---