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

What do you mean by worklet?

631


What is aggregate cache in aggregator transformation?

631


What are the prerequisite tasks to achieve the session partition?

713


Is stop and abort are same in informatica?

570


What is the difference between stop and abort in informatica

661






Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6469


Can we get 1st record through Informatica(without sequence number).

984


What is an aggregator transformation?

617


What is a repository? And how to add it in an informatica client?

653


How would you join a node to the already existing domain?

679


What is primary and backup node?

694


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1407


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1528


What is dimensional table?

619


How to extract sap data using informatica?

607