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 CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE
USING SQL T/R ?

Answer Posted / ankit kansal

The Problem asked about deleting rows using SQL T/R...

So write a sql query like
Delete from table name where col_name = ?input_port?

This is how u will be able to delete a particular row using SQL trans..

http://deepinopensource.blogspot.in/

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 incremental aggregation?

1132


Explain what is informatica metadata and where is it stored?

1103


How can we improve session performance in aggregator transformation?

1149


Repository user profiles

1809


where to store informatica rejected data? How to extract the informatica rejected data?

1051


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

2194


What is rank transformation in informatica

1229


What is a standalone command task?

1246


what are the Methods For Creating Reusable Transformations?

1249


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2403


What could be the possible resons of locks by user?

1140


Explain the code page compatibility?

1114


What are the measure objects?

1251


Enlist the differences between database and data warehouse.

1164


Explain the types of lookup transformation?

1100