What is the use of upsert command in teradata?
Answer / praveen kota
It is a update or insert. If the updating row exists in target table, it will update else it will insert the data
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the different functions performed in development phase?
How to run the Teradata jobs in unix environment ???
How many tables can you join in v2r5?
Find 2 highest sal from each dept who have completed 5 year in org
i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.
where we can use the delimiter in mload? pls let me know
What's the syntax of sub string?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
Why is the case expression used in teradata?
How is Teradata in current market?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table
Why does varchar occupy 2 extra bytes?