difference between source based commit? and target based
commit? which is better with respect to performance?

Answer Posted / srinu

source based commit,Target based commit
Both are Having the Same importence.
You can go for commit based on Importence,Requirement only.

If your source have limit then go for source based commit,
If your Target have limit then go for Target based commit.

Any ??? or Corrections,,let me know
‘Srinu.srinuvas@gmail.com ‘

Is This Answer Correct ?    8 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by active and passive transformation?

679


How to update a particular record in target with out running whole workflow?

1242


Define pmcmd command?

714


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3620


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

879






What are the tuning techniques you applied during your last project

1661


Which version configuration tool used in ur project?

2864


Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1504


Can you generate sequence numbers without using the sequence generator transformation?

672


Write the advantages of partitioning a session?

853


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9289


What is a predefined event?

751


What is a difference between complete, stop and abort?

739


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1283


how tokens will generate?

1840