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

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

More Teradata Interview Questions

Explain the most common data types used in teradata?

0 Answers  


how do you handle ET and UV errors ?

2 Answers  


What does sleep function does in fast load?

0 Answers  


Why do you get spool space errors? How do trouble-shoot them?

0 Answers  


Explain about Skew Factor?

6 Answers   TCS,






What are the steps to create a data model?

0 Answers  


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

0 Answers   Infosys, Wells Fargo,


in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?

2 Answers   HCL,


Explain teradata architecture in detail with a diagram.

0 Answers  


what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)

4 Answers  


Why is the case expression used in teradata?

0 Answers  


What is the process to restart the multiload if it fails?

7 Answers  


Categories