where we can use the delimiter in mload? pls let me know
- 2 Answers
- 8086 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
When tpump is used instead of multiload?
teradata support to automatically increase the character length or not?
I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.
What is a dimension table?
what is use of PI(primary index) AND SI(secondary index)
I 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?
How can bottlenecks be identified?
What are the scenarios in which full table scans occurs?
What are the components used in smp and massively parallel processing (mpp) machines?
Hi 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
What is the maximum number of dml can be coded in a multiload script?
what are the file sizes in your project?
Teradata 
