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
Explain in detail about scd type 1 through mapping.
What you know about transaction control transformation?
What are the components of the workflow manager?
What do you mean by filter transformation?
can we override a native sql query within informatica? Where do we do it?
What are the guidelines to be followed while using union transformation?
What is a predefined event?
Explain direct and indirect flat file loading (source file type) - informatica
What are the tasks that can be performed using sq?
What is a passive transformation?
What are the types of caches in lookup?
Can we get 1st record through Informatica(without sequence number).
Why filter transformation is an active one?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?