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

How will you update the first four rows and insert next
four rows in a mapping?

Answer Posted / tejal

We can use an expression transform after the source quailifier - define a variable / counter port and increment it for each run.
Output this counter value and pass it to a router , which has 2 groups based on this value counter <=4 then insert else update.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the command used to run a batch?

1004


What is a pre-defined event and user-defined event?

983


Briefly define reusable transformation?

1081


What is the benefit of session partitioning?

1056


What is Session and Batches?

1048


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2086


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8177


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3830


What are the features of complex mapping?

1105


What is the status code in stored procedure transformation?

1130


Does an informatica transformation support only aggregate expressions?

981


What is informatica worklet?

995


How can a transformation be made reusable?

1088


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2194


How you prepared reports for OLAP?

1560