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

What is limitations of truncate and load option

Answer Posted / abhinaw prakash

You cannot rollback the data in case of failed session.
In this scenario you need to write delete query(delete from
tablename) and uncheck the Truncate target table option.

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the fact table?

1069


can we override a native sql query within informatica? Where do we do it?

1122


What are the tasks that can be performed using sq?

1091


What is olap (on-line analytical processing?

1067


What are the components of workflow manager?

1096


Define enterprise data warehousing?

1201


How you can differentiate between connected lookup and unconnected lookup?

1062


What is the format of informatica objects in a repository?

1019


what is INFORMATICA TESTING process

2289


Explain direct and indirect flat file loading (source file type) - informatica

1318


what is size of u r database?

2305


What is a difference between complete, stop and abort?

1083


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2280


What are the conditions needed to improve the performance of informatica aggregator transformation?

1093


how we can load rejected record's at run time?(not through bad files)

2379