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.

What is the scenario which compels informatica server to reject files?

0 Answers  

how to connect two or more table with single source qualifier?

4 Answers   IBM,

Where is metadata stored?

0 Answers  

Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

3 Answers   CTS,

Explain transaction control transformation in informatica

0 Answers   Informatica,

Can we change Dynamic to Static or Persistent cache? If so what happens?

0 Answers   TCS,

How you prepared reports for OLAP?

0 Answers  

what is size of u r database?

0 Answers  

In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav

5 Answers  

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,