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 dynamic cache?

614

---

How to configure mapping in informatica?

676

---

What does command task mean?

614

---

What is sorter transformation?

585

---

How will the document be delivered to me?

619

---

---

Explain the shared cache and re-cache?

613

---

How is union transformation utilized?

571

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2070

---

what is diff b/t sorter t/r and agg have the option sorter property...

1748

---

How can you increase the performance in joiner transformation?

712

---

Performance tuning( what you did in performance tuning)

1489

---

Explain the etl program with few examples.

548

---

Explain the types of transformations?

597

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

601

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

1845

---