explain the scenario for bulk loading and the normal
loading option in Informatica Work flow manager ???

Answer Posted / sankar

NORMAL LOADING:THE INTEGRATION SERVUCE CREATE THE DATA BASE
LOG BEFORE LOADING DATA INTO THE THE TARGET DATA BASE.SO
--THE INTEGRATION SERVICE PERFORM ROLL BACK AND SESSION
RECOVERY.
BULK LOADING:THE INTEGRATION SERVICE IN WORK THE BULK
UTILITY WHEN BYPASS THE DATA BASE LOG
--THIS IS IMPROVES THE PERFORMANCE DATA LOADING
--THIS IS NOT PERFORM ROLLBACK

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6603


Explain lookup transformation in informatica

832


What is workflow? What are the components of workflow manager?

926


What is the difference between source qualifier transformations source filter to filter transformation?

849


What is depict expression change?

806


Where do we use mapping variables in informatica?

814


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

848


What do you mean by worklet?

830


What is substr in informatica?

896


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1916


what is the size of your data warehousing?

1862


What is mapplet in informatica?

770


What are the tasks that source qualifier perform?

831


How to open an older version of an object in the workspace?

844


What are pre and post-session shell commands?

1007