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 / shyam

by using dd_delete(2) in UPDATESTRATAGY trnsformation we
can delete rows.

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dynamic cache?

1079


What is target designer and target load order?

1166


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2791


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

1131


What is the difference between a connected look up and unconnected lookup?

998


What are connected or unconnected transformations?

1171


What does update strategy mean, and what are the different option of it?

1140


what is index?how it can work in informatica

2081


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1176


What are the restrictions of union transformation?

1084


How many ways are there to do 'remove duplicate records in informatica'?

1061


What is a difference between complete, stop and abort?

1123


Separate from an archive server and a powerhouse?

1005


Repository user profiles

1809


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

1267