Interested to Buy Any Domain ? << Click Here >> for more details...
wt is the difference between truncate and delete in which
situation u use delete and truncate in real time..
- 4 Answers
- 13672 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / siva
In addition to Mukesh's answer, the truncate and delele
commands can also used on partitions in Oracle to truncate
or delete the records from the particular partition..
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How to create or import flat file definition in to the warehouse designer?
In warehouses how many schemas are there?
Differentiate between Load Manager and DTM?
How to do unit testing in informatica?
What are the prerequisite tasks to achieve the session partition?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How to do the error handling of if ur source is flatfiles?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Explain the different lookup methods used in informatica?
What are the settings that you use to configure the joiner transformation?
What is dynamic cache?
Define the various join types of joiner transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
pmscmd startworkflow -sv
