Answer Posted / rakesh

The main difference between normal and bulk load is, in normal load Informatica repository service create logs and in bulk load log is not being created. That is the reason bulk load loads the data fast and if anything goes wrong the data can not be recovered. But in normal load since the log is created the lost data can be recovered.

By configuring session to Bulk loading we cannot do 'session recovery' when it get failed whereas in normal loading we can easily do session recovery.

Note:In normal load Informatica creates logs record by record in database level and in bulk mode it will not create detail log. By avoiding that detail writing in bulk mode improve performance.

Note:If there are indexes and constraints in the table, you cannot use Bulk Load
You can drop/disable those indexes/constraints (pre session ) , then load the data (use Bulk Load) , and then create/enable the indexes/constraints (post session )

what is the Default Source Option For Update Strategy Transformation?

1241

---

What are the different components of powercenter?

1055

---

Describe the impact of several join conditions and join order in a joiner transformation?

1063

---

what is the hint? how to use it to reduce the query processing in program?

7836

---

Separate from a database, an information bazaar, and an information stockroom?

1089

---

Enlist the advantages of informatica.

1068

---

What are the different options available for update strategy?

1004

---

If informatica has its scheduler why using third party scheduler?

1268

---

Define update strategy?

1230

---

How do you handle two sessions in Informatica

1164

---

What is status code in informatica?

1021

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1767

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1080

---

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2107

---

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2036

---