Answer Posted / babu

Hi,

Wf-->s1-->Assignmenttask(var=var+1)--mod(var,5=0)-->s2
here var is variable it is declared in workflow level.
if every run of workflow var value increase 1,whenevr the
var reaches the value is 5 then only s2 will run.



Babu

What is a difference between complete, stop and abort?

1071

---

Why filter transformation is an active one?

965

---

Explain why we use partitioning the session in informatica?

1071

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1751

---

What is a filter transformation?

1024

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1071

---

Please let me know how to make encryption and decryption with example?

1886

---

What is a rank transform?

1072

---

How big was your fact table

1785

---

lookup transformation with screenshots

3985

---

What all join we can perform in LOOKUP transformation?

954

---

Differentiate between a repository server and a powerhouse?

1102

---

Differences between version 7.x and 8.x.

1881

---

What is powercenter on grid?

1166

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2301

---