Interested to Buy Any Domain ? << Click Here >> for more details...
explain the scenario for bulk loading and the normal
loading option in Informatica Work flow manager ???
- 8 Answers
- 36941 Views
- CTS, TCS, I also Faced
- E-Mail Answers
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
What the difference is between a database, a data warehouse and a data mart?
What is a standalone command task?
What is incremental aggregation?
What is rank transform?
How union transformation is used?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
what is the size of u r source(like file or table)?
Explain constraint based loading in informatica
What are Dimensional table?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is union transformation in informatica?
Explain incremental aggregation in informatica
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What are the restrictions of union transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
