Answer / satya

In addition to Kapil's answer, You can have "push down"
optimization at source database or target database or Full
(Source and target). But before you enable this option you
keep the following things in mind

1. When you are processing long transaction at database
level , The objects will be lock and data base objects are
not available for other operations for long time.

2. It will inturn hampers the datbase concurrency and
increases the chance of "Dead locks" on database

Thanks : Satya

Answer / kapil

The Pushdown Optimization Option improves performance by
enabling processing to be “pushed down” to a
relational database, maximizing fl exibility, minimizing
unnecessary data movement, and providing the optimal
performance for both data-intensive and process-intensive
transformations.

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

0 Answers   HP,

---

What are the types of maping in Getting Started Wizard?

1 Answers  

---

What is different between informatica version 8 and 9 version

1 Answers   Cognizant, IBM,

---

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,

---

Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?

4 Answers  

---

What are the types of caches in lookup?

0 Answers  

---

Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that

5 Answers   TCS,

---

what is confirmed fact?

2 Answers  

---

Which is the t/r that builts only single cache memory?

0 Answers  

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

0 Answers  

---

What is IQD file?

1 Answers  

---