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 are active and passive transformations?

1091

---

What is the use of code page?

1100

---

How can we improve session performance in aggregator transformation?

1125

---

How to configure mapping in informatica?

1179

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

2201

---

How do you promote a non-reusable transformation to reusable transformation?

1138

---

Which version configuration tool used in ur project?

3267

---

What are the different lookup cache(s)?

1128

---

How can a transformation be made reusable?

1177

---

Mention a few design and development best practices for informatica?

1004

---

How would you join a node to the already existing domain?

1135

---

What is the advantage of informatica?

1071

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2129

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1713

---

How many types of sessions are there in informatica.please explain them?

1175

---