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
What is a filter transformation?
Explain what are the different versions of informatica?
Define enterprise data warehousing?
lookup transformation with screenshots
Explain about Informatica server process that how it works relates to mapping variables?
What is target load order?
Is there any way to read the ms excel datas directly into informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are different types of transformations available in informatica?
How can repository reports be accessed without sql or other transformations?
Clarify the aggregator change?
Please let me know how to make encryption and decryption with example?
Enlist the advantages of informatica.
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What are the settings that you use to configure the joiner transformation?