Interested to Buy Any Domain ? << Click Here >> for more details...
wt r before journal& after journel.....in teradata
- 4 Answers
- 9599 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 |
Explain teradata vs. Redshift?
What are the different methods ot loading a dimension table? A fact table etc?
What is spool space? Why do you get spool space errors?
If RDBMS is halted what will you do ?
What are the functions involved in shared information architecture?
What happens when a node suffers a downfall?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
what is differences between Fastload and Multiload as per DBA aspect ?
What is meant by a Clique?
what is object level locking ? where do appear this type of locking ?
Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH CONTAIN ALPHANUMERIC AND NUMERIC VALUES. C1 2A 2B 2V 2H 1 2 3 4 5 i want to retrive numeric values like 1,2,3,4,5 How we can get Plz let me know.Thanks in advance
What is the purpose of using case expression in teradata?
Teradata 
