where we can use the delimiter in mload? pls let me know
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
i am not sure about the question. But vartext is one of the input file formats which is supported in mload. VARTEXT is one of the option.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / tdguy
delimiter is used along with vartext option. Two
consecutive delimiters instructs teradata to insert a null
for that field.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the use of having index's on table?
what is object level locking ? where do appear this type of locking ?
Can you load multiple data files for same target table using fastload?
If the table does not have duplicates then which utility you can suggest to load the data ?
write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH CONTAIN ALPHANUMERIC AND NUMERIC VALUES. C1 2A 2B 2V 2H 1 2 3 4 5 i want to retrive numeric values like 1,2,3,4,5 How we can get Plz let me know.Thanks in advance
What is basic teradata query language?
List out teradata data types?
What is meant by a node?
How do you create a table with an existing structure of another table with data and with no data?
Explain teradata utilities. What is multiload, fast load, tpump?
What are the differences between TerdataV2R5 and V12 Versions please??