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

wt is the difference between truncate and delete in which
situation u use delete and truncate in real time..

Answer Posted / bose3508

After completion of history extraction from database you
may go for truncate.To cleanse the oltp database.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to do unit testing in informatica? How to load data in informatica ?

1182


What is repository manager?

1025


What is the sql query overwrite in source qualifier in informatica

1141


if we have a delimiters at unwanted places in a flat file how can we over come those.

2086


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1170


where to store informatica rejected data?

1139


How can we update a record in the target table without using update strategy?

1201


What is parallel processing in informatica?

1789


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2106


While importing the relational source definition from the database, what are the metadata of source that will be imported?

1315


what is mean by complex business rule ?

2218


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1843


whats the logic to load the lower level of granularity of data to fact table.

2309


What is meant by target load plan?

1028


How to use procedural logic inside infromatica?

1320