Answer / venkateshmalneni

We use bulk loading in such senarious where there is bulk amount of data is to be loaded into target.
ie we when we want yo load large amount of data fast into the target we use bulk loading.
when u dont want to do the session recovery and u r target should not contain any primary keys
we use normal loading in such senarious when u want to do session recovery.It looks about the constrain based
loding

Answer / amol palekar

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.

Different sorts of metadata that stores in the storage facility?

0 Answers  

---

what happens if you try to create a shortcut to a non- shared folder?

1 Answers  

---

one source to target loading insert new rows and update existing rows?

3 Answers   Polaris,

---

Types of error logs in Informatica?

2 Answers  

---

Why we use lookup transformations?

1 Answers  

---

I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?

1 Answers   Cognizant, HCL,

---

What is InformaticaPowerCenter?

0 Answers   Informatica,

---

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  

---

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

---

write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

8 Answers   TCS,

---

How do you load only null records into target? Explain through mapping flow.

0 Answers  

---

how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

---