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 to delete the data in the target table after loaded.

Answer Posted / venky

write post sql in target table as truncate table tablename

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what transformation and how many are there in informatica?

890


Explain informatica architecture - version 8 / 9

1021


Slowly changing dimensions, types and where will you use them

1654


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7072


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

2206


What are the differences between oltp and olap?

921


How do you load only null records into target? Explain through mapping flow.

1956


What is mapplet in informatica?

982


Design a mapping to load the cumulative sum of salaries of employees into target table?

1423


Is there any way to read the ms excel datas directly into informatica?

978


What is target load order?

1187


What is fact table? Explain the different kinds of facts.

1010


Explain scd type 3 through mapping.

917


Please let me know how to make encryption and decryption with example?

1847


What is meant by lookup transformation?

1034