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

Hi Friends,
I want lo truncate my records from target before loading
current month data,but i dont have permission to truncate
with truncate option
if u know any other way please give your valuable input for
this.

Thanks
Abhishek

Answer Posted / raj

Use delete * .... in pre-sql

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

976


Explain dynamic target flat file name generation in informatica

1053


Differences between version 7.x and 8.x.

1893


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1068


Different circumstance which drives informatica server to expel records?

983


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1075


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2554


What are the main features of Oracle 8i with context to datawarehouse?

2112


Which development components of informatica have the highest usage?

1041


Enlist few areas or real-time situations where informatica is required.

1084


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2160


What is native users?

1158


How we can create indexes after completing the load process?

1160


What are the types of presistent cache in look up tr.

2055


What do think which one is the better joiner or look up?

1203