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
- 6767 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is the meaning of upgradation of Repository?
When do we analyze the tables? How do we do it?
what is the meant by Normalization and de-normalization?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
when will use SQL override in a lookup transformation?
How to delete data which is not in source table?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
What are the various tools used in etl?
What is full load & incremental or refresh load?
What is partitioning? Explain about round-robin, hash partitioning.
what is a worklet?
what is the difference between cubes and package in cognos
what is session partitioning?
Do we need an etl tool?
