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
What is rank transform?
where to store informatica rejected data? How to extract the informatica rejected data?
Briefly explain the aggregator transformation?
What is blocking transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How can we use mapping variables in informatica?
What happens when a session fails and you click on recover?
What is a node in Informatica?
Which transformation should we use to normalise the COBOL and relational sources?
Can you use flat files in Mapplets.
is it possible to index the data in cache of lkp transformation ?
Briefly define reusable transformation?
What are the differences between oltp and olap?
How do you load only null records into target?