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 i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

0 Answers  

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,

why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,

Explain reference cursor?

1 Answers  

How to get EVEN & ODD numbers separately?

8 Answers  

What are data-driven sessions?

0 Answers  

What are the types of lookup?

3 Answers   Wipro,

What do you understand by SOA of Informatica?

0 Answers  

Explain the pipeline partition with real time example?

0 Answers   Informatica,

Which gives the more performance when compare to fixed width and delimited file ? and why?

3 Answers   HP,

how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers   emc2,

Enlist few areas or real-time situations where informatica is required.

0 Answers  

For more Informatica Interview Questions Click Here
Categories