Answer / guest

If you enable bulk loading, the PowerCenter Server
bypasses the database log.This improves session performance.
But the disadvantage is that target database cannot perform
rollback as there is no database log.

In normal load the databse log is not bypassed and
therefore the target databse can recover from an incomplete
session.The session performance is not as high as is in the
case of bulk load

Answer / harithareddy

normal load performance recovery is possible where as in
bulk mode it is not possible bez, there is no databaselog
to perform rollback

Answer / kiran

they are right

Answer / sid

1.Can anybody tell me how to rollback data when sessions
fails...

2. where does the database logs will be created.

Answer / sachin

1.It is also not allow the constraint when we make Target load type as Bulk Mode
2.Also we do not allow to use indexes on database level in Bulk mode But in Normal mode we can allow indexes as well as constraint.

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers  

---

How to configure mapping in informatica?

0 Answers  

---

What are the new features in Informatica 5.0?

1 Answers  

---

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

8 Answers   HeadStrong, TCS,

---

what are the different types of transformation available in informatica and what are the mostly used ?

3 Answers   TCS,

---

---

What are the differences between joiner transformation and source qualifier transformation?

0 Answers   Informatica,

---

what is junk dimension

4 Answers   Cap Gemini,

---

differences between service based and product based?

0 Answers   Satyam,

---

how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table

2 Answers  

---

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,

---

How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   iFlex, TCS,

---

explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,

---