Answer Posted / ramesh.b

hi,
normally router means multiple targets...take 2 groups first group condition isnull and second group condition not isnull.first group gives the null values and second group gives the non null values.

source-->sq-->expression-->router-->2 targets

Explain sql transformation in script mode examples in informatica

1209

---

What is the session task and command task?

1111

---

What do think which one is the better joiner or look up?

1242

---

How many dimensions are there in informatica?

1132

---

Explain why we use partitioning the session in informatica?

1161

---

What are the popular informatica products?

1054

---

What is a joiner transformation and why it is an active one?

1163

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2102

---

What is workflow monitor?

1099

---

Explain the shared cache and re-cache?

1163

---

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

1137

---

How you prepared reports for OLAP?

1654

---

What are the issues you have faced in your project? How did you overcome those issues?

2410

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1208

---

What is meant by a domain?

1186

---