Journal is prevents from image failure. these are 3 types they are 1.Re

wt r before journal& after journel.....in teradata

Question Posted / charan

4 Answers
9439 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Name the five phases that come under MultiLoad Utility.

928

Describe the between keyword in teradata?

980

Explain teradata vs. Redshift?

956

What is meant by a Highest Cost Plan?

988

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2796

Difference between stored procedure and macro?

1109

Highlight the limitations of TPUMP Utility.

1048

List the logical and conditional operators that are used with teradata along with their meanings?

939

Highlight the differences between Primary Key and Primary Index.

1016

What are the primary characteristics of the Teradata.

1058

What happens in a conflict? How do you handle that?

987

Explain the term 'columns' related to relational database management system?

988

What is dimensional modeling?

1013

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

979

How can bottlenecks be identified?

956