Answer Posted / sudheer113

 The Designer does not allow you to connect multiple active transformations or an active and a passive transformation to the same downstream transformation or transformation input group because the Integration Service may not be able to concatenate the rows passed by active transformations. For example, one branch in amapping contains an Update Strategy transformation that flags a row for delete. Another branch contains an Update Strategy transformation that flags a row for insert. If you connect these transformations to a single transformation input group, the Integration Service cannot combine the delete and insert operations for the row.

Define filter transformation?

1048

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2282

---

Explain how many types of dimensions are available in informatica?

1041

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2091

---

COM components can be used in Informatica

2340

---

Explain the shared cache and re-cache?

1069

---

Enlist few areas or real-time situations where informatica is required.

1041

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2008

---

How to delete duplicate row using informatica?

998

---

Explain joiner transformation in informatica

1094

---

Repository user profiles

1726

---

Explain load alternative records / rows into multiple targets - informatica

1115

---

have u done any performance tuning? how u ll do?

2259

---

What is the use of source qualifier?

1088

---

What are ETL Tools?

1064

---