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


After a load is done to my target table, I need to insert a
last row, which might be formed at some expression
transformation and brought to target. Do I have to have
separate mapping to be run after the 1st mapping? Or in a
single mapping how to achieve this?

Answer Posted / arun

Guess the questione was something different. Need is to add a footer record at the end of the target. This can be done with one mapping, have two pipelines.
1) TO load to target
2) To Load last record to target.

Change the target load plan, to make sure the last record pipeline runs last.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is there any way to read the ms excel datas directly into informatica?

1022


Explain Dataware house architecture .how data flow from intial to end?

2581


What are data-driven sessions?

1193


What are the different ways to implement parallel processing in informatica?

1423


How we can create indexes after completing the loan process?

1208


Can informatica load heterogeneous targets from heterogeneous sources?

1185


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1793


Explain sql transformation in script mode examples in informatica

1132


Why update strategy and union transformations are active?

1041


What happens when a session fails and you click on recover?

1120


What is substr in informatica?

1206


To import the flat file definition into the designer where should the flat file be placed?

1059


What are the designer tools for creating transformations?

1115


What is the difference between STOP and ABORT options in Workflow Monitor?

1257


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1774