Answer Posted / 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

is it possible to index the data in cache of lkp transformation ?

1958

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1026

---

Differentiate between a repository server and a powerhouse?

1041

---

Enlist some properties of sessions.

1018

---

What is a sequence generator transformation?

950

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1020

---

What are the advantages of informatica?

956

---

How do you load alternate records into different tables through mapping flow?

1801

---

What are the tasks that source qualifier perform?

1028

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1931

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1021

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2120

---

Can we create two repositories on same database instance in oracle?

1013

---

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1804

---

Explain what are the different versions of informatica?

1030

---