Interested to Buy Any Domain ? << Click Here >> for more details...
wt r before journal& after journel.....in teradata
- 4 Answers
- 9667 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 |
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale
What are the available primary index types?
What is the diffrence between Multiload & Fastload interms of Performance?
how do you handle ET and UV errors ?
I WANT TO LEARN TERA-DATA ,SO CAN ANY BODY PLZ REFER WHAT ARE THE TOPICS I HAVE TO GO THROUGH, TO GET ASAP JOB ,SO PLZ REFER ME WHERE I CAN GET NICE COACHING ON TERADATA.
How to select first n records in teradata?
Explain Teradata performance tuning and optimization?
Mention a few of the ETL tools that come under Teradata.
What is a common data source for the central enterprise data warehouse?
What are the various reporting tools in the market?
If table have access lock.In the same table write lock is posible or not?
Teradata 
