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

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1994

---

What are the new features of informatica 9.x at the developer level?

987

---

tell me about your project functionality

2296

---

Explain what are the different versions of informatica?

1037

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1744

---

What are active and passive transformations?

1023

---

During the running session, output files are created by informatica server. Enlist few of them.

935

---

What are the types of schemas we have in data warehouse and what are the difference between them?

890

---

Define Pmrep command?

998

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4071

---

Parameter and variable differences

2007

---

What is workflow manager?

991

---

To import the flat file definition into the designer where should the flat file be placed?

1008

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1092

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6915

---