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

What are the types of caches in lookup?

1052

---

What are the limitations of joiner transformation?

1114

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1037

---

What is the session task and command task?

1064

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1207

---

What is a filter transformation?

1050

---

What are the different types of repositories created using informatica?

1143

---

Design a mapping to load a target table with the following values from the above source?

1352

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1983

---

Mention some types of transformation?

1048

---

What is the commit type if you have a transaction control transformation in the mapping?

1036

---

How to join three sources using joiner? Explain though mapping flow.

1152

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1285

---

Quickly characterize reusable change?

1127

---

What are the guidelines to be followed while using union transformation?

1146

---