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

Answer Posted / sankar

NORMAL LOADING:THE INTEGRATION SERVUCE CREATE THE DATA BASE
LOG BEFORE LOADING DATA INTO THE THE TARGET DATA BASE.SO
--THE INTEGRATION SERVICE PERFORM ROLL BACK AND SESSION
RECOVERY.
BULK LOADING:THE INTEGRATION SERVICE IN WORK THE BULK
UTILITY WHEN BYPASS THE DATA BASE LOG
--THIS IS IMPROVES THE PERFORMANCE DATA LOADING
--THIS IS NOT PERFORM ROLLBACK

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain constraint based loading in informatica

851


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1848


can anyone suggest best free Talend data integration training online

1496


How can you differentiate between powercenter and power map?

854


Explain the informatica workflow?

834


What is difference between a gateway node and worker node?

882


What are the data movement modes in informatica?

911


What is meant by pre and post session shell command?

873


Explain transaction control transformation in informatica

1047


How can repository reports be accessed without sql or other transformations?

977


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1696


How many number of sessions can one group in batches?

917


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

838


how we can load rejected record's at run time?(not through bad files)

2156


What are the designer tools for creating transformations?

904