explain the scenario for bulk loading and the normal
loading option in Informatica Work flow manager ???

Answer Posted / rekha

NORMAL LOAD : IT LOADS THE RECORD ONE BY ONE AND WRITES LOG
FOR EACH FILE . IT TAKES MORE TIME TO COMPLETE
BULK LOAD : I LOAD THE NUMBER OF RECORDS AT A TIME ,IT WONT
FALLOW ANT LOG FILES OR TRACE LEVELS . IT TAKES LESS TIME
USE THE BULK MODE FOR IMPROVING THE SESSION PERFORMANCE

Is This Answer Correct ?    49 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which version configuration tool used in ur project?

2760


Can we create multiple integration service on single repository?

694


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1609


what are the Methods For Creating Reusable Transformations?

642


What are the limitations of joiner transformation?

646






In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5231


Design a mapping to load the cumulative sum of salaries of employees into target table?

888


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

544


How to configure mapping in informatica?

669


what is the size of your data warehousing?

1667


What do you understand by SOA of Informatica?

580


What are the modules in Power Center

1218


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

797


What is meant by query override?

630


What are different types of transformations available in informatica?

578