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

Question Posted / cherry56779

4 Answers
9438 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / yuvaevergreen

before journals and after journals are used to maintain images of the table before and after the changes.

Is This Answer Correct ?

2 Yes

0 No

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

Answer / mahesh

Can you please explain in detail. Before changes means ( After
inserting the first data and before changes ?) After changes means ( will it keep on taking images when ever the change happened ?) please clarify me .

Thanks in advance

Is This Answer Correct ?

1 Yes

0 No

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

Answer / 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

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

Answer / tdguy

Before and after journal options are part of permanent
journal. Before journal capture the state of the object
before the change. After journal captures the state of the
object after the change.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer