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

Thanks

Could you explain what is enterprise data warehouse?

1148

---

What does reusable transformation mean?

1132

---

How to join three sources using joiner?

1115

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2339

---

What is meant by LDAP users?

1209

---

What is workflow monitor?

1062

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2001

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

976

---

Sequence generator, when you move from develoment to production how will you reset

2038

---

Which transformation is needed while using the Cobol sources as source definitions?

1174

---

What is persistent lookup cache?

1029

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2122

---

how tokens will generate?

2204

---

Describe the impact of several join conditions and join order in a joiner transformation?

1063

---

Partition, what happens if the specified key range is shorter and longer

2499

---