wt is the difference between truncate and delete in which
situation u use delete and truncate in real time..
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
What is informatica worklet?
Explain pmcmd command usage in informatica
How can we remove the duplicates from flat file source?
Describe expression transformation?
How to update source definition?
What are active and passive transformations?
What is the need of an ETL tool?
How can we delete duplicate rows from flat files?
how tokens will generate?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How are indexes created after completing the load process?
What is joiner change?
design of staging area?
Define filter transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?