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 lookup change?

1112


Do you find any difficulty while working with flat files as source and target?

1151


Explain your project of banking domian.

1694


Name the different lookup cache(s)?

1294


Mention some types of transformation?

1101


What is session task and command task?

1401


Explain why we use partitioning the session in informatica?

1167


Explain the difference between mapping parameter and mapping variable?

1083


How can we create index after completion of load process?

1168


Where can we find the throughput option in informatica?

1109


What is substr in informatica?

1265


What are the new features of informatica 9.x developer?

1034


Write the prerequisite tasks to achieve the session partition?

1233


What is meant by a domain?

1189


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2249