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
How do you take back up of repository?
Define pmcmd command?
How do you manage the Parameter files while migrating your data from one environment to another environment?
what are factless facts? And in which scenario will you use such kinds of fact tables.
How many ways a relational source definition can be updated and what are they?
Is it possible to define a single node as a Gateway node as well as worker node?
Write the program through which the records can be updated?
How do you remove duplicate records in informatica? And how many ways are there to do it?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What's the layout of parameter file (what does a parameter file contain?)?
How many numbers of sessions can one group in batches?
How to go to the older version for a mapping?
where to store informatica rejected data?
what is the size of your data warehousing?
As union transformation gives UNION ALL output, how you will get the UNION output?