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 aggregate cache in aggregator transforamtion?

5 Answers  

---

How to call shell scripts from informatica?

1 Answers  

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1 Answers   IBM,

---

what is difference between mapping and mapplet ?

2 Answers   TCS,

---

what is data modelling? what are types of modelling?In which suituation will use each one?

1 Answers   Accenture,

---

Write the advantages of partitioning a session?

1 Answers  

---

Can you use one mapping to populate two tables in different schemas

2 Answers  

---

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,

---

Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

3 Answers   Syntel,

---

Different types of Power center errors?

1 Answers   Cinterco, IBM,

---

In development project what is the process to follow for an etl developer from day1

1 Answers  

---

what type of transformation is not supported by mapplets?

4 Answers   CTS,

---