Answer Posted / charan
Journal is prevents from image failure.
these are 3 types
they are
1.Recovery journal 2. Transient Journal 3.permanent Journal
Images are defined into 4 types based on Journals
they are,
1.single image 2.Dual image 3.Before Image 4.After Image
Single image: It Takes the one copy of the data
Dual Image : It Takes 2 copies of data
Before Image: It takes copy of the data before operation
After Image : it takes copy of the data after operation
Recovery Journal:
It will useful for Recovery the data.Suppose if there is any fail will happen in AMP
Transient Journal:
It will useful for the data if there is any operation fails means go to the previous step.
Permanent journal:
It will takes the data for Partial and full recovery
for,
Partial Recovery:
B.I+(Mon to Sun) A.I
Full Recovery:
B.I.+(Mon to Wed) A.I.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the various etl tools in the market?
Explain the most common data types used in teradata?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What is the difference between teradata and oracle?
Is multi insert ansi standard?
What is teradata and why it is used?
What are aggregate tables? How do you design them using teradata?
During the Display time, how is the sequence generated by Teradata?
What is the function of parser component in teradata?
What is the command in bteq to check for session settings ?
What is called partitioned primary index (ppi)?
How do you see a ddl for an existing table?
What are the different functions performed in development phase?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
My table got locked during mload due to a failed job. What do I do to perform other operations on it?