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
Explain pushdown optimization $pushdownconfig parameter - informatica
What is option by which we can run all the sessions in a batch simultaneously?
Define enterprise data warehousing?
How many ways are there to create ports?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
In warehouses how many schemas are there?
Can anyone tell me the new features in Informatica 9 Version?
How can you generate reports in informatica?
is it possible to index the data in cache of lkp transformation ?
What is transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
difference between repository database and repository service?
Differentiate between reusable transformation and mapplet.
What is the difference between router and filter?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks