Answer Posted / ankur

small change in the above post..
add an exp after source qualifier...with two more ports

v_out as variable =iif((is_number(inputport),v_out,v_out+1)
output=v_out

so output from this exp will be
1 0
2 0
3 0
* 1
4 1
5 1
6 1
* 2
7 2
8 2
8 2

now add a filter where output=1 and in_number(input)

Thanks

What is a repository manager?

1030

---

Explain what are the different versions of informatica?

1037

---

Briefly describe lookup transformation?

982

---

Which transformation should we use to normalise the COBOL and relational sources?

1143

---

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

1536

---

What is the surrogate key?

1149

---

What is the cumulative sum and moving sum?

1139

---

Write the program through which the records can be updated?

938

---

Explain the informatica workflow?

1005

---

what is index?how it can work in informatica

1982

---

Why do we need informatica?

928

---

what is the difference between informatica6.1 and infomatica7.1

2186

---

What is powercenter on grid?

1129

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1052

---

What is a joiner transformation?

940

---