what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)
4 14664i 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
1755id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???
6 12060whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?
HCL,
5 8508
What are the things to be considered while creating secondary index?
What is the opening step in basic teradata query script?
What is database exceptions in teradata?
What are aggregate tables? How do you design them using teradata?
Explain amp in teradata?
What is called partitioned primary index (ppi)?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What can be achieved by using the teradata rdbms?
Explain how spool space is used.
Explain Teradata performance tuning and optimization?
Define views in teradata with general syntax.
If RDBMS is halted what will you do ?
how many modules are there in telecome domain?how to explain the architecture?
Highlight the need for Performance Tuning.