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
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 ?
Explain lookup transformation in informatica
What is workflow? What are the components of workflow manager?
What is the difference between source qualifier transformations source filter to filter transformation?
What is depict expression change?
Where do we use mapping variables in informatica?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What do you mean by worklet?
What is substr in informatica?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
what is the size of your data warehousing?
What is mapplet in informatica?
What are the tasks that source qualifier perform?
How to open an older version of an object in the workspace?
What are pre and post-session shell commands?