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
How to load data from multiple files to single target?
What are the constraints are used in Ur project?
What is variable? What is Flow of variable?
how to load the data with one flat file and one rdbms table using joins?
What is Journalization and why we are using in ODI?
How many types of km's? And you what are the type's km are used in your project?
What is File steps?
What is CKM and when we will use this CKM?
What is the data quality in odi?
explain what is odi?why is it different from the other etl tools.
does odi support web services?
what is load plans and types of load plans?
how to implement the logic in procedures if the source side data deleted that will reflect the target side table?
What are the IKM types?
Have you created fact table and dimension tables?