explain the scenario for bulk loading and the normal
loading option in Informatica Work flow manager ???
Answer Posted / rajkumar bachu
1)Bulkload & Narmal load
Normal: In this case server manager allocates the
resources(Buffers) as per the parameter settings. It creates
the log files in database.
Bulk: In this case server manager allocates maximum
resources(Buffers) available irrespective of the parameter
settings. It will not create any log files in database.
In first case data loading process will be time taking
process but other applications are not affected. While in
bulk data loading will be much faster but other application
are affected.
Is This Answer Correct ? | 12 Yes | 13 No |
Post New Answer View All Answers
permutations of mapplet
What is the cumulative sum and moving sum?
How to convert multiple rows to single row (multiple columns) in informatica
What are the types of lookup transformation?
is it possible to index the data in cache of lkp transformation ?
What is the sql query overwrite in source qualifier in informatica
Enlist the various types of transformations.
Explain the different lookup methods used in informatica?
Explain why we use partitioning the session in informatica?
What is the way to execute pl/sql script using informatica mapping?
What is the difference between router and filter?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is target designer and target load order?
complex mapping ur project u r invlve can u explain and give real time example give me ?
How can we delete duplicate rows from flat files?