Answer Posted / jhilam roy

The answer is conditional.

1. If both the active and passive transformations belong to
the same pipeline, then the answer is VALID. Example: see
SCD mappings.

2. On the other hand, if the active and the passive
transformation belong to two different pipelines, then the
answer is INVALID. Example: you can try it on your own and
cross-check the correctness of the answer.

Hope, this clarifies any doubt.

What is the function of look up transformation?

1053

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1994

---

How can you generate reports in informatica?

971

---

Describe the impact of several join conditions and join order in a joiner transformation?

1006

---

How to handle decimal places while importing a flatfile into informatica?

1127

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1217

---

What all are steps in up gradation of Informatica server?

984

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1891

---

What is flashback table ? Advance thanks

1869

---

What is decode in static cache?

1074

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1216

---

tell me about your project functionality

2288

---

In informatica workflow manager, how many repositories can be created?

1259

---

Write the prerequisite tasks to achieve the session partition?

1069

---

How to convert multiple rows to single row (multiple columns) in informatica

1315

---