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

How do you set a varible in incremental aggregation

1451

---

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.

1856

---

Differentiate between router and filter transformation?

617

---

What is a node in Informatica?

629

---

What is repository manager?

538

---

---

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

633

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

1812

---

Enlist the tasks for which source qualifier transformation is used.

591

---

How many ways are there to do 'remove duplicate records in informatica'?

587

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1789

---

how to load rows into fact table in data warehouse

642

---

How many ways a relational source definition can be updated and what are they?

583

---

Define sessions in informatica etl?

619

---

What is union transformation?

575

---

Suppose we do not group by on any ports of the aggregator what will be the output?

582

---