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
- 6608 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
Identifying the bottlenecks in various components of Informatica and resolving them.
where are the log files generally stored.Can you change the path of the file.what can the path be?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What are materialized views & where do we use them?
What are three tier systems in etl?
Explain the key challenges that you face while performing etl testing.
Do we need an etl tool?
What are the three tiers in etl?
how would u estimate the size of Aggregator transform data and index cache?
what is dynamic insert?
what happens if the info.server doesn't find the session parameter in the parameter file?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
What is etl tool in hadoop?
Explain me ETL project architecture in Detail?
What is etl process. How many steps etl contains explain with example?
