Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between normal and bulk loading?
Which one is recommended?
- 1 Answers
- 5997 Views
- I also Faced
- E-Mail Answers
Answer / rakesh
The main difference between normal and bulk load is, in normal load Informatica repository service create logs and in bulk load log is not being created. That is the reason bulk load loads the data fast and if anything goes wrong the data can not be recovered. But in normal load since the log is created the lost data can be recovered.
By configuring session to Bulk loading we cannot do 'session recovery' when it get failed whereas in normal loading we can easily do session recovery.
Note:In normal load Informatica creates logs record by record in database level and in bulk mode it will not create detail log. By avoiding that detail writing in bulk mode improve performance.
Note:If there are indexes and constraints in the table, you cannot use Bulk Load
You can drop/disable those indexes/constraints (pre session ) , then load the data (use Bulk Load) , and then create/enable the indexes/constraints (post session )
| Is This Answer Correct ? | 14 Yes | 0 No |
normalizer transformation
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
what is mapping performence?
How to create or import flat file definition in to the warehouse designer?
What is an expression transformation?
Please let me know how to make encryption and decryption with example?
How many ways a relational source definition can be updated and what are they?
can a port in expression transf be given the name DISTINCT
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
What is a stored procedure transformation?
what is a time dimension? give an example?
What is lookup transformation?
Teradata 
