Answer Posted / venki
Delete means when we deleted the row and columns in the table.Then we can give the rollback command again it will regain the data to the table
Truncate means when we deleted the row and columns in the table.it will be deleted permanently rollback command won't work here
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
in the package one interface got failed how to know which interface got failed if we no access to operator?
What are the types of Knowledge Modules?
How many types of dimensions in oracle?
Difference between 10g & 11g in odi?
What is Session Tasks?
Can migrate the one ORACLE DATA INTEGATOR studio to another ORACLE DATA INTEGATOR studio?
Difference between ETL and E_LT?
how to write the procedures in odi?
If you are working Microsoft excel, which type of file you used .excel or .csv?
What is ELT? Or What is the difference between ODI and other ETL Tools?
What is J2EE Agent and port number?
what is oracle data integrator (odi)?
how to load the data with one flat file and one rdbms table using joins?
suppose having unique and duplicate but I want to load unique record one table and duplicates one table?
Have you created fact table and dimension tables?