Answer / chanti

Genrally, data base opertions are more faster than
operations that are excuted under power center.

The main idea behind pushdown optmization is to push some
of the transformation logic to either source side or target
side data base, so that performance can be improved.

Answer / sudhar

Pushdown optimization is used to push the complex logic to
the database level. This will reduce the complexity of the
Powercenter mappings and increases the performance.

Answer / rekha

IN GENERAL DATABASE OPERATONS ARE MORE FASTER THAT
EXEXUTING IN THE POWERCENTER,SO WE CAN MOVE THE COMPLEX
TRANSFORMATION LOGIC TO DATABASE FOR PERFORMNACE IMPROVE

Answer / ashok1729

pushdown optimization will improve the performance of the
Load...

Let's see the E.g:

Sq ---> Flter_t ----> Target
[ sal<2000 ]

....

Answer / shiva

understanding the transfromatin language,and analize the
tranfromation language time being taken to achieve the
taske ,then push the trasnformtin logic either source
database or targer database.

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

3 Answers   HP,

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

In target table how to display the system time

1 Answers  

Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 Answers  

i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?

3 Answers   IBM,

how we can do session partition in informatica any one explain me clearly? thanks advance.

1 Answers   iGate,

How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,

Explain about Informatica server process that how it works relates to mapping variables?

0 Answers   Informatica,

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??

3 Answers   IBM,

What are the informatica performance improvement tips

0 Answers   Informatica,

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,