in what type of scenario bulk loading and normal loading we use?
Answer Posted / venkateshmalneni
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 |
Post New Answer View All Answers
What are the guidelines to be followed while using union transformation?
What is the cumulative sum and moving sum?
What are the types of lookup transformation?
differences between service based and product based?
Explain pushdown optimization $pushdownconfig parameter - informatica
Mention few power centre client applications with their basic purpose?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are the types of schemas we have in data warehouse and what are the difference between them?
what is $$$$?
Mention a few design and development best practices for informatica?
tell me the rules and responsblites in our project(my project is development)
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is a rank transform?
can anyone suggest best free Talend data integration training online
What is joiner transformation?