Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between normal & bulk loading? and
which one is recommended ? why?
- 2 Answers
- 6856 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
normalloding:
this is the optin which we to set in the session under
mapping tab.this will represents the loading of data into
target.this is slower when compared to bulk load.this can
load the data even if u have constraints built on u r
target.this will create the session logs
bulloading
it is the faster loading method.we can' load if u have
constraint defined.this will not create sesion logs
generally normal loading is preffered
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / prasanna
Session log is always created in any mode you load. The
loading method is no way realted to creation of a session
log.
Normal mode: Will check for constraints while loading. Its
a process which happens record by record.
Bulk mode: This will not check for any constraints on DB.
So, generally when you don;t have any indexes or
constraints defined on your target table, you can use Bulk
mode which is faster.
In Informatica 8.6.1 , if you define bulk mode also.. if
your task need to perform Normal mode operation,
informatica will chabge it to Normal mode automatically run
time.
| Is This Answer Correct ? | 3 Yes | 0 No |
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
what are the different forms of normalization?
how to answer the question "explain project architecture" in informatica pls any one who has the answer pls send the answer to this mail id "karumanchisrinu@gmail.com
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
what is the difference between cardinality and Nullability?
what is the main role of FI on business
what is pmrep command?
How to delete data which is not in source table?
0 Answers IBM, Saama Tech, Wipro,
what are the data modeling tools you have used?(polaris)
Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com
320 Answers Accenture, College School Exams Tests, CTS, Flextronics, HCL, Infosys, NexGen, Patni, SO, Wipro,
What is a mapping?
how do use session mapping parameters ?(in which transformation)
Teradata 
