Interested to Buy Any Domain ? << Click Here >> for more details...
in what type of scenario bulk loading and normal loading we use?
- 2 Answers
- 6637 Views
- Cognizant, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
We use bulk loading in such senarious where there is bulk amount of data is to be loaded into target.
ie we when we want yo load large amount of data fast into the target we use bulk loading.
when u dont want to do the session recovery and u r target should not contain any primary keys
we use normal loading in such senarious when u want to do session recovery.It looks about the constrain based
loding
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / amol palekar
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
I have a flat file, want to reverse the contents of the flat file
What are the types of groups in Router transformation?
how to declare array in plsql?
what is parameter file?
How are indexes created after completing the load process?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need
What is log file,and where is it located,why u r using the log file
What are the different types of transformation available in informatica.
what is the function of 'F10' informatica ?
what is mean by grouping of condition column in lookup transformation?
What are the types of caches in lookup?
Teradata 
