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
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Different circumstance which drives informatica server to expel records?
What are the popular informatica products?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Explain in detail scd type 2 through mapping.
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is a difference between complete, stop and abort?
Under what condition selecting sorted input in aggregator may fail the session?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
tell me about your project functionality
What are 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?
server hot-ws270 is connect to Repository B. What does it mean?
What are the different types of olap? Give an example?
Quickly characterize reusable change?
How do you load unique records into one target table and duplicate records into a different target table?