Answer Posted / ankur saini

hey guys c if this works...

add an exp after source qualifier...with two more ports

v_out as variable =iif((is_number(inputport),0,v_out+1)
output=v_out

so output from this exp will be
1 0
2 0
3 0
* 1
....
* 2
...

now add a filter where output>0

Thanks

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

2500

---

What is a mapplet/worklet in informatica?

1189

---

How can you differentiate between powercenter and power map?

1093

---

What's the layout of parameter file (what does a parameter file contain?)?

2388

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8224

---

What is sequence generator transformation in informatica?

1081

---

EXL informatica Questions

1395

---

Clarify the aggregator change?

1033

---

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2307

---

Is stop and abort are same in informatica?

1003

---

can we override a native sql query within informatica? Where do we do it?

1124

---

What are the types of schemas we have in data warehouse.

964

---

How to differentiate between the active and passive transformations?

1169

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1071

---

Why update strategy and union transformations are active?

1046

---