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

Implementation methodology

1714

---

Explain the etl program with few examples.

1050

---

How do you take back up of repository?

1162

---

How to update or delete the rows in a target, which do not have key fields?

1178

---

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

2179

---

What is a predefined event?

1093

---

Differentiate between reusable transformation and mapplet.

1096

---

Explain transaction control transformation in informatica

1268

---

Explain sessions. Explain how batches are used to combine executions?

1034

---

How do you convert single row from source into three rows into target?

1157

---

how many types of dimensions are available in informatica?

1100

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2037

---

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

4109

---

What does refresh system mean, and what are its distinctive choice?

1181

---

How do you use reject loader.

2605

---