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

When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?

1 Answers  


how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  


Make a note of the quantity vaults made in informatica?

0 Answers  


i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,


can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,






How can i set break points in debugging mode ? can explain steps please?

1 Answers   ABC, TCS,


i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....

4 Answers   TCS,


How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,


how we do performence tuning in informatica

3 Answers  


sample mappings for scd1,scd2 and scd3

2 Answers   Cognizant,


what is bridge tables in informatica

1 Answers   CTS,


hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,


Categories