Answer Posted / anusha n

Fatal error occurs when integration service unable to fetch source, target or repository. when session encounters fatal error, integration service terminates session.

Non fatal occurs records to be dropped from ETL Process. It doesn't force session to stop.

hi real timers . iam waiting for ur reply regarding ETL TESTING

2263

---

What is sq transformation?

1153

---

What are the new features of Power Center 5.0?

1766

---

Different sorts of metadata that stores in the storage facility?

1007

---

COM components can be used in Informatica

2378

---

Explain load alternative records / rows into multiple targets - informatica

1143

---

Please let me know how to make encryption and decryption with example?

1891

---

What are the measure objects?

1196

---

What are connected or unconnected transformations?

1112

---

Why do we need informatica?

982

---

What are the guidelines to be followed while using union transformation?

1132

---

How to update a particular record in target with out running whole workflow?

1568

---

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.

2191

---

What are the types of schemas we have in data warehouse and what are the difference between them?

936

---

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

1085

---