Can we Suggest as how is the process to get a job in teradata in current market??Is it easier???
IBM,
1 4164hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?
1 3141Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this regard. Thanks in advance.
4 12441Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD
6 9941I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?
IBM,
4 8843Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M
6 10602Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq
3 6321I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata
3 7403
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What are the different table types supported by teradata?
How to load specific no.of records using bteq, or fastload,or multiload
What do you mean by teradata intelliflex?
Difference between stored procedure and macro?
How do you determine the number of sessions?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is smp and mpp platforms?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
In Teradata, how do we Generate Sequence?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What are the joins in teradata and how many types of joins are there in teradata?
What is meant by a node?
