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 are the circumstances that infromatica server results an unreciverable session?

1 Answers  

can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,

Can a joiner be used in a mapplet.

1 Answers  

What is confirmed dimension and fact?

7 Answers  

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,

what are the output files that the informatica server creats during running a session?

2 Answers   CTS,

what type of transformation is not supported by mapplets?

4 Answers   CTS,

I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers   TCS,

Explain why we use partitioning the session in informatica?

0 Answers  

Can we update the data in flat file using update strategy?

3 Answers  

What happens if we dont select data driven option?

2 Answers   Zensar,

can we override a native sql query within informatica? Where do we do it?

0 Answers