I have a source either file or db table Eno ename sal dept 101 sri 100 1 10

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?

Question Posted / dine

2 Answers
7410 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 l..

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

Is This Answer Correct ?

11 Yes

0 No

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 l..

Answer / raj

With the help of mapping variable.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer

More Informatica Interview Questions

i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers HCL,

tell me 7.x and 8.x diferrencess(but not transformations)

1 Answers

Why the workflow is failed after running two hours in informatica?

1 Answers GE,

How you load distinct records into one target and duplicate records into another target?

3 Answers Mphasis,

what is the command to get the list of files in a directory in unix?

5 Answers iGate,

what are the Methods For Creating Reusable Transformations?

0 Answers Informatica,

Differentiate between a database and data warehouse?

0 Answers

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?

6 Answers

Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani

2 Answers Wipro,

What do you mean by channel change?

0 Answers

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

0 Answers

Explain what are the different types of transformation available in informatica.

0 Answers

For more Informatica Interview Questions Click Here