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

Explain pushdown optimization and types in informatica

1122

---

Describe an informatica powercenter?

1194

---

What is the Process to creating lookup transformation in informatica

1091

---

What are the advantages of using informatica as an etl tool over teradata?

1077

---

how to load dimension table and fact table. plz tell me the steps.

2143

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1212

---

Define filter transformation?

1149

---

How many ways are there to create ports?

1404

---

How to create or import flat file definition in to the warehouse designer?

1135

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2073

---

Do you find any difficulty while working with flat files as source and target?

1149

---

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

2024

---

What is the difference between a repository server and a powerhouse?

1578

---

Explain sessions and how many types of sessions are there?

1060

---

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

4152

---