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
Where can we find the throughput option in informatica?
Did u used latest transformations of 8.6.0? for what?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Explain constraint based loading in informatica
What are connected or unconnected transformations?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is the benefit of partitioning a session?
How to load data in informatica ?
Enlist some properties of sessions.
What could be the possible resons of locks by user?
What is the sql query overwrite in source qualifier in informatica
In how many ways we can create ports?
How to extract sap data using informatica?
In warehouses how many schemas are there?