in what type of scenario bulk loading and normal loading we use?

Answer Posted / amol palekar

main difference between normal and bulk load is, in normal load Informatica repository service create logs and in bulk load log is not being created. That is the reason bulk load loads the data fast and if anything goes wrong the data can not be recovered. But in normal load since the log is created the lost data can be recovered.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the reusable transformation?

632


Is it possible to define a single node as a Gateway node as well as worker node?

663


What is substr in informatica?

665


How might one distinguish in the case of mapping is right or not without associating session?

642


if we have a delimiters at unwanted places in a flat file how can we over come those.

1572






Explain the mapping variable usage example in informatica

635


What is informatica etl tool?

556


can you please explain me pre session and post session options?

6388


What are the issues you have faced in your project? How did you overcome those issues?

1917


can anyone suggest best free Talend data integration training online

1263


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1650


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1513


Target increases every day even though no new record was inserted

1111


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1612


How to load the data from people soft hrm to people soft erm using informatica?

564