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? ..

Answer / kalpana

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

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  


Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 Answers  


Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,


What are parallel querys and query hints?

1 Answers  


TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,






How does the aggregator transformation handle null values?

0 Answers  


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,


comonly how meny mappings r there in Banking projects?

1 Answers  


How mapping parameter and variable works

1 Answers  


write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

3 Answers   iGate,


what is the difference between Informatica7.1 & informatica 8.1

4 Answers  


how to we create datamart?

2 Answers   HSBC,


Categories