Answer Posted / etl maha guru

Hey fools, understand the question. The question is "Data
is passed from one active trans and one passive trans
into a passive transformation.Is the mapping valid or
invalid?"
The answer is: Mapping is invalid. We can never connect a
data from Active and passive transformation TO A PASSIVE
TRANSFORMATION (Coming from different pipelines, we should
take the question in this way). Can you connect output of a
joiner and Expression to an expression transformation
(where output of joiner and expression coming from
different pipelines).

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1610

---

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

1568

---

Briefly define a session task?

1106

---

How to call shell scripts from informatica?

986

---

What is the function of look up transformation?

1109

---

What could be the possible resons of locks by user?

1078

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1839

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2251

---

What are mapplets? How is it different from a Reusable Transformation?

1073

---

can anyone explain me about retail domain project in informatica?

7929

---

What is difference between a gateway node and worker node?

1116

---

r u done any partitions in ur project?

1811

---

can u any challenge your project?

2018

---

 Informatica Checkpoints

3310

---

How do you promote a non-reusable transformation to reusable transformation?

1118

---