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

What is a shortcut and copy in Informatica and how two are different with each other?

1235


Briefly describe lookup transformation?

1090


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1552


Which transformation should we use to normalise the COBOL and relational sources?

1266


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

2194


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

2641


How can we use mapping variables in informatica? Where do we use them?

1279


How to join three sources using joiner?

1187


What is different between the data warehouse and data mart?

1108


Repository user profiles

1804


Where are the source flat files kept before running the session?

1136


What is meant by active and passive transformation?

1189


Clarify the aggregator change?

1073


What is the sequence generator transformation in informatica?

1258


how to load rows into fact table in data warehouse

1224