What is the difference between SI and JI?
Answers were Sorted based on User's Feedback
Answer / veena
SI is like pointer to the base rows where as JI stores actual rows
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sivareddy
si it avoids the full table scan nd it gives the fast reterival of the data and use the extra perm space where as join index it holds the one or more then tables data nd stored in perm space.at the time of joined two table it will take data from join index.and also it will use aggregate operations,anylatical operations.
Is This Answer Correct ? | 1 Yes | 0 No |
What do you mean by ttu in teradata?
Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update
Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What exactly do you know about catching in teradata?
in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that
What are teradata utilities?
In BTEQ, how are the session-mode parameters being set?
How do you define Teradata?
I have all the TERADATA Certification Dumps for the below: NR0-011, NR0-012, NR0-013, NR0-014 NR0-015 NR0-016, NR0-017 If anyone need it, pls drop me a mail with Code in the mail to: terashish@gmail.com
201 Answers Cognizant, Deloitte, IBM, Prometric, Syntel,
What is the difference between fastload and multiload? Which one is faster?
Can any one plz provide the teradata interview questions?