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...

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?

Answer Posted / raj

With the help of mapping variable.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you find any difficulty while working with flat files as source and target?

1098


What is the need of etl tools?

1120


what is mean by complex business rule ?

2162


Briefly explain the aggregator transformation?

1008


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

2066


how to load dimension table and fact table. plz tell me the steps.

2094


What can we do to improve the performance of informatica aggregator transformation?

1095


Describe expression transformation?

1126


How to create the source and target database connections in server manager?

1090


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2158


What is the advantage of informatica?

1069


Explain how to import oracle sequence into informatica?

1011


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2036


Which transformation is needed while using the Cobol sources as source definitions?

1174


Write the prerequisite tasks to achieve the session partition?

1158