Answer Posted / thava

Pipeline term in informatica means the way source is flow
to target via any transformation e.g filter transformation

How to generate sequence numbers?

1040

---

Explain lookup transformation is active in informatica

1045

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1755

---

What is workflow? What are the components of the workflow manager?

1078

---

How would you join a node to the already existing domain?

1082

---

Mention few power centre client applications with their basic purpose?

902

---

What are the differences between joiner transformation and source qualifier transformation?

1111

---

Explain incremental aggregation in informatica

1085

---

How to join three sources using joiner? Explain though mapping flow.

1109

---

explain about unit testing? in real time?

2152

---

How to create Target definition for flat files?

1171

---

What happens when a session fails and you click on recover?

1084

---

how many types of dimensions are available in informatica?

1021

---

What is an active transformation?

1047

---

I have a flat file, want to reverse the contents of the flat file

1075

---