what are cost based and rule based approaches and what is the difference?

what are cost based and rule based approaches and what is
the difference?

Question Posted / guest

what are cost based and rule based approaches and what is the difference? ..

costbased and rule based approaches r used as optimization
techniques in improving the performance of queries

Is This Answer Correct ?

1 Yes

0 No

More Informatica Interview Questions

get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

wt is inline view? when and why we Use ?mail to rayallarv@gmail.com

Differentiate between source qualifier and filter transformation?

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

What are the static cache and dynamic cache in informatica?

How union transformation is used?

What is a surrogate key?

how to convert the .doc docs into .txt format using informatica

Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.

i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

can any one explain me about junk dimension

What are the session parameters?

For more Informatica Interview Questions Click Here