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
- 6716 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 are the types in error loging?
What are snapshots?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
how do u really know that paging to disk is happening while u are using a lookup transform?
what is an ETL or ETT? And what are the different types?
What is a mapping, session, worklet, workflow, mapplet?
Explain what is etl process? How many steps etl contains explain with example?
What are the types of Data Warehouse applications?
what is data modeling?
Can there be sub steps of etl steps?
what make u disappointmnets in u r career
what is Forward,Reverse and Re_engineering?
What is grain of fact?
How to delete data which is not in source table?
where we cannot use sorter Transformation. if we use then we will not get correct data?
