Answer / Chandra Mohan Jha

Active Transformations in Informatica refer to the executing or running transformations within a session. They consist of both source and target qualifiers, transformation logic, and workflows that define the data flow. These transformations process data as per the specified rules, filters, and transformations.

can u give example for factless fact table

3 Answers   TCS,

---

Difference Between ETL & ELT?

1 Answers   TCS,

---

Explain the mapping variable usage example in informatica

1 Answers   Informatica,

---

What is an Integration service in Informatica?

1 Answers  

---

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers   TCS,

---

What is blocking transformation?

1 Answers   Informatica,

---

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,

---

What is the default source option for update stratgey transformation?

1 Answers  

---

Whatis the difference between View and Materialized View ?

11 Answers   Satyam, Syntel,

---

How to extract the informatica rejected data?

1 Answers  

---

i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater

5 Answers  

---

What are the types of caches in lookup?

1 Answers  

---