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.

Explain the flow of data in Iinformatica?

1 Answers  

---

Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

2 Answers   Infotech,

---

Types of error logs in Informatica?

2 Answers  

---

How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,

---

What are the components of the workflow manager?

0 Answers  

---

---

what is mystery dimension?

1 Answers  

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

0 Answers  

---

2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?

2 Answers   Emphasis,

---

wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

---

what is the difference between onsite & client site?

1 Answers  

---

How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?

2 Answers   Rolta,

---

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,

---