Answer / Himansh Upriyada Rsh

In Informatica, a Passive Transformation is a type of transformation that does not create any output data stream. Instead, it receives an input data stream and performs various operations like filtering, aggregation, or lookup, but does not produce an output data stream.nnPassive transformations are useful in scenarios where you want to perform some operations on the data without producing a new output stream. They can be used as intermediate steps in a workflow.

what is mean by throghput? in informatica

3 Answers   Cap Gemini,

---

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1 Answers   IBM,

---

Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you

6 Answers  

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1 Answers   IBM, TCS,

---

In a concurrent batch if a session fails, can you start again from that session

1 Answers  

---

Why we need XMLs?

3 Answers   IBM,

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

1 Answers   Cap Gemini, Cognizant,

---

How do you do error handling in Informatica?

1 Answers  

---

what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,

---

can u give example for factless fact table

3 Answers   TCS,

---

What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  

---