There is a table with 4 columns in that 3 columns has been
already loaded with 5 million records.4th column is
empty,Now I have got 5 million records data which has to be
loaded into 4th column.How can I load this data fastly in to
the 4th column with out using update
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
1.The last column has to be loaded from the file.
2.The file has also got the other three columns with it.
3.Access has been given to create tables.
>>Since, update cannot be used, mload update script may not
>>TPUMP and BTEQ would be slow.
>>So, my option would be
* create new_table as table with no data;
* Use the fastload to load the empty table with the 5
million rows from the file.
* rename table table to old_table;
* rename new_table to table;
|Is This Answer Correct ?||12 Yes||4 No|
Answer / tdguy
Incase if you have priveleges to delete the data, delete
and load all the 4 columns using fload utility. Else use
bteq and load all the 4 columns in a volatile table
followed by delete and loading into target table. But this
would be slow when compared to fload.
|Is This Answer Correct ?||3 Yes||0 No|
Answer / anil
For this question you have to ask clearly is that data
wants to load fresh or they want to load override ,Or is it
same data next time also getting 5 million records .If we
getting same records again 5 million records then use Mload
1) write 2 staments in mload 1st insert into temp table
then again temp table to select only 4th column and insert
into original table(select 4 column) this is one type of
2) Then again load by using fast load it will not takes big
|Is This Answer Correct ?||3 Yes||2 No|
Answer / pavan
The update is not accessible,so we cannot use the FLOAD
Utility why because FLOAD is the utility only used to
insert that to incae of empty tables only. and we can go
for MLOAD utility.
|Is This Answer Correct ?||3 Yes||3 No|
Answer / mohan
I would prefer to go with Multiload utility. Since we are
not sure all the records from flat file are equivalent to
the data which are already stored in teradata database. so
if we use multiload upsert concept we can load newly
available data as well as can update the 4th column. And we
can easily pick up the details how many new and how many are
updated, etc., etc., Please let me know if it makes sense!!!
|Is This Answer Correct ?||1 Yes||1 No|
IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.
Give a justifiable reason why Multi-load supports NUSI instead of USI.
In general, how do you optimze any sql in teradata?
How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????
Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"
How to find duplicates in a table?
How to run the Teradata jobs in unix environment ???
If the script is aborted. why it is aborted and how can you identify ?
Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?
Explain teradata vs. Redshift?
What is meant by a node?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me