Answer / srinivas

create a mapping variable
example;
name type datatype pre scal agg
$variablename variable decimal 3 0 max

filter transformation
filter condition: setvariable($variablename,($variablename+1))

+1 is used as the consecutive deptno diff is 1

Answer / raj

With the help of mapping variable.

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

2 Answers   TCS,

---

when will we go for unconnected lookup transformation in Informatica?

6 Answers   CTS, IBM,

---

in a table it has 200 rows the query is select 150 from tablename.whats the output

2 Answers   Cap Gemini,

---

Define the various join types of joiner transformation?

0 Answers  

---

Kimball and Inmon methodologies?

2 Answers  

---

As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 Answers  

---

How are the sources and targets definitions imported in informatica designer?

0 Answers   Informatica,

---

In target table how to display the system time

1 Answers  

---

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers  

---

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

---

What is a filter transformation and why it is an active one?

0 Answers  

---

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,

---