Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

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

can u give example for factless fact table

2 Answers   TCS,

Explain pmcmd command usage in informatica

0 Answers   Informatica,

What are the mapping paramaters and mapping variables?

1 Answers  

Explain sessions and how many types of sessions are there?

0 Answers  

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 Answers  

How do we call shell scripts from informatica?

0 Answers  

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

what are the settiings that u use to cofigure the joiner transformation?

2 Answers  

What are the types of presistent cache in look up tr.

0 Answers   IBM,

What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,

In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?

4 Answers  

What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 Answers  

For more Informatica Interview Questions Click Here
Categories