What is the difference between SOURCE and TARGET BASED
COMMITS?

Answer Posted / suresh

source based means not depending upon how many records
written to target,the Integration service commit data.

target commit means not depending upon how many records read
from source it will commit.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the etl program with few examples.

543


Differentiate between Load Manager and DTM?

1661


How big was your fact table

1310


What is data caches/ index caches?

611


Explain lookup transformation is active in informatica

657






What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1656


What is an unconnected transformation?

659


Scheduling properties,whats the default (sequential)

1460


What are the modules in Power Center

1225


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

671


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

671


What are the types of schemas we have in data warehouse.

526


What do you understand by SOA of Informatica?

583


Design a mapping to load the cumulative sum of salaries of employees into target table?

889


How do you load alternate records into different tables through mapping flow?

1286