Interested to Buy Any Domain ? << Click Here >> for more details...
explain the scenario for bulk loading and the normal
loading option in Informatica Work flow manager ???
- 8 Answers
- 36933 Views
- CTS, TCS, I also Faced
- E-Mail Answers
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 transaction control transformation?
What does refresh system mean, and what are its distinctive choice?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are multi-group transformations?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Difference between Data and Index Caches?
What is aggregator transformation in informatica?
How are the sources and targets definitions imported in informatica designer?
How to load a Dimension ? and how to load a fact table?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Explain the types of transformations?
What are the modules in Power Center
what are the Methods For Creating Reusable Transformations?
write a query to retrieve the latest records from the table sorted by version(scd)
