Answer Posted / 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.

How does hashing happens in teradata?

1073

---

Explain the term 'foreign key' related to relational database management system?

1018

---

What interface is used to connect to windows based applications?

1100

---

What is bteq script in teradata?

1134

---

Explain parsing engine in teradata?

1070

---

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

2042

---

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

2194

---

any one answer me how they can analyzing the project using data ware housing?

2455

---

What are the scenarios in which full table scans occurs?

994

---

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2152

---

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1939

---

What is the purpose of joins in teradata?

1147

---

What are default access rights in teradata? What explicit right can be given to a user?

1093

---

What is the use of virtual processor connectivity in teradata?

987

---

Define views in teradata with general syntax.

1017

---