wt r before journal& after journel.....in teradata
- 4 Answers
- 8245 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 happen if a query fail in dispatcher?
Explain Teradata performance tuning and optimization?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
How does hashing happens in teradata?
I want to write one query How to get Matched records and unmatched records in table?
What are the various indexes in teradata? How to use them?
Explain some differences between mpp and smp?
Highlight the limitations of TPUMP Utility.
What is partitioned primary index (ppi)?
IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance
2 Answers Cap Gemini, IBM, Infosys,
How can we check the version of Teradata that we are using currently?
In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??
Teradata 
