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

How to eliminate duplicates from flat file..what is the procedure

4 Answers  


How can you increase the performance in joiner transformation?

0 Answers  


What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

1 Answers   Qwest,


what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,


what is incremental aggregation ,with example?

2 Answers  






What are the tuning techniques you applied during your last project

0 Answers  


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  


How You Pull the records on daily basis into your ETL Server.

2 Answers   TCS,


I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers   IBM,


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

0 Answers   CTS,


What is option by which we can run all the sessions in a batch simultaneously?

0 Answers   Informatica,


What are Dimensional table?

0 Answers   Informatica,


Categories