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



What is limitations of truncate and load option..

Answer / 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

More Informatica Interview Questions

what is mean by throghput? in informatica

3 Answers   Cap Gemini,


can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,


What are mapplets? How is it different from a Reusable Transformation?

0 Answers   Informatica,


i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers  


How many ways are there to create ports?

0 Answers   Informatica,


What is facttable granularity?

2 Answers  


what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,


How to Join Tables my Source is having 15 table target is one?

4 Answers   TCS,


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

0 Answers  


On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 Answers  


Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,


r u done any partitions in ur project?

0 Answers   TCS,


Categories