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

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6282

---

What is meant by active and passive transformation?

1192

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1205

---

Explain the mapping variable usage example in informatica

1224

---

What is Index Caches size?

1164

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2248

---

What do you understand by term role-playing dimension?

1117

---

What are mapplets? How is it different from a Reusable Transformation?

1136

---

What is option by which we can run all the sessions in a batch simultaneously?

1192

---

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

1758

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1141

---

Define enterprise data warehousing?

1257

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2082

---

Mention few advantages of router transformation over filter transformation.

1069

---

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

1140

---