major difference between normal loading and bulk loading?
Answer Posted / ananta mishra
1-normal loading will load data first in log file then load
in target.
but bulk loading load the data directly in target.
2- performance will increase where bulk loading will use.
3-u can't recover data when use bulk loading.so for that we
have to start workflow again.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we change Dynamic to Static or Persistent cache? If so what happens?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What will be the approach?
Different qualification between a related rotate toward the sky and isolates look upward?
How might you approve all mappings in the archive all the while?
How can we delete duplicate rows from flat files?
What is union transformation?
Clarify the aggregator change?
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?
Mention some types of transformation?
What is depict expression change?
What are different types of transformations available in informatica?
What is workflow? What are the components of workflow manager?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How do you load unique records into one target table and duplicate records into a different target table?