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 meant by query override?

631

---

can u give example for factless fact table

5507

---

Which development components of informatica have the highest usage?

590

---

Explian the Process of deployment groups in informatica

651

---

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

721

---

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1638

---

What is dynamic cache?

608

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1964

---

What is event and what are the tasks related to it?

612

---

Explain the informatica workflow?

582

---

Difference between Target-based loading and constraint-based loading?

548

---

Can anyone tell me the new features in Informatica 9 Version?

1527

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

3503

---

Difference between Data and Index Caches?

647

---

How to use procedural logic inside infromatica?

629

---