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

in the warehouse designer,in targets ,in generate and
execute option truncate the table

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention some types of transformation?

1048


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


What is session task and command task?

1297


What is a surrogate key?

1081


Sequence generator, when you move from develoment to production how will you reset

2039


What can we do to improve the performance of informatica aggregator transformation?

1095


What is the format of informatica objects in a repository?

1019


What is olap (on-line analytical processing?

1069


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2237


explain one complex mapping with logic? sales project?

6669


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

1209


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1053


can you please explain me pre session and post session options?

7566


What is the use of source qualifier?

1138


hi real timers . iam waiting for ur reply regarding ETL TESTING

2271