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


Please Help Members By Posting Answers For Below Questions

permutations of mapplet

2138


What is the cumulative sum and moving sum?

866


How to convert multiple rows to single row (multiple columns) in informatica

1017


What are the types of lookup transformation?

724


is it possible to index the data in cache of lkp transformation ?

1625






What is the sql query overwrite in source qualifier in informatica

709


Enlist the various types of transformations.

647


Explain the different lookup methods used in informatica?

686


Explain why we use partitioning the session in informatica?

683


What is the way to execute pl/sql script using informatica mapping?

1083


What is the difference between router and filter?

722


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?

8929


What is target designer and target load order?

743


complex mapping ur project u r invlve can u explain and give real time example give me ?

1955


How can we delete duplicate rows from flat files?

849