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 to delete the data in the target table after loaded.

Answer Posted / honey

SQ---> Properties tab-->Post SQL
delete from target_tablename

SQL statments(s) executed using the source database
connection, after a pipeline is run

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by active and passive transformation?

1027


How to do the error handling of if ur source is flatfiles?

1906


What is decode in informatica?

1071


What is option by which we can run all the sessions in a batch simultaneously?

1077


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10629


How do you update the records with or without using update strategy?

1050


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

977


How would you join a node to the already existing domain?

1065


Define the various join types of joiner transformation?

940


What are the differences between joiner transformation and source qualifier transformation?

1094


What is meant by lookup transformation?

1032


How to load last n records of file into target table - informatica

1018


What is a predefined event?

1028


How does a sorter cache works?

999


How to extract the informatica rejected data?

1158