Interested to Buy Any Domain ? << Click Here >> for more details...
wt r before journal& after journel.....in teradata
- 4 Answers
- 9606 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
What can be achieved by using the teradata rdbms?
id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???
Explain the term 'tables' related to relational database management system?
Define views in teradata with general syntax.
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What is meant by Teradata Gateway?
Describe primary index in teradata?
Highlight the points of differences between the database and user in Teradata.
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What are the steps involved after the disk manager passes the request?
Different phases of multiload?
How do you define Teradata?
Teradata 
