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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How can repository reports be accessed without sql or other transformations?

714


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6384


What are the features of complex mapping?

631


What are the guidelines to be followed while using union transformation?

628


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1021






Can we create two repositories on same database instance in oracle?

600


What are ETL Tools?

653


How do we call shell scripts from informatica?

583


What is the scenario which compels informatica server to reject files?

590


explain one complex mapping with logic? sales project?

6131


Difference between Target-based loading and constraint-based loading?

544


How to do the error handling of if ur source is flatfiles?

1495


Differentiate between router and filter transformation?

600


Which transformation should we use to normalise the COBOL and relational sources?

736


What is repository manager?

526