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 internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,

how to load rows into fact table in data warehouse

0 Answers   Informatica,

What is a filter transformation?

0 Answers  

how much memory (size) occupied by a session at runtime

4 Answers   Wipro,

Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,

What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

3 Answers   Amdocs, Deloitte,

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,

whats the logic to load the lower level of granularity of data to fact table.

0 Answers   IBM,

what we require for D.modelling?

1 Answers  

What's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,

what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,

how to get the first row without using rank t/r?

7 Answers   iGate,