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

How to generate sequence numbers using expression transformation?

1026


What is the cumulative sum and moving sum?

1136


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2293


what are the deliverables?in your project?

2084


How to Create a folder using pmrep command?

1104


In informatica workflow manager, how many repositories can be created?

1267


Can you generate sequence numbers without using the sequence generator transformation?

1049


can u any challenge your project?

1971


What is option by which we can run all the sessions in a batch simultaneously?

1078


How to load the data from people soft hrm to people soft erm using informatica?

949


Suppose we do not group by on any ports of the aggregator what will be the output?

982


Explain sessions and how many types of sessions are there?

955


Where are the source flat files kept before running the session?

1011


What is session task and command task?

1176


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1585