How do you load Multiple files to a table by using fastload
scripts?
- 1 Answers
- 11271 Views
- Satyam, I also Faced
- E-Mail Answers
Answer / vinay
Remove End Loading statement in the script and Replace the
file one by one in the script till last file and submit
everytime so that data appended in Amp Level.
For the last file specify End Loading stmt in the script
and Run.so that it runs frm Amp to table.
| Is This Answer Correct ? | 10 Yes | 0 No |
Why are oltp database designs not generally a good idea for a data warehouse?
What are the different functions included in the server software?
what is differences between Fastload and Multiload as per DBA aspect ?
what are the uses of fact table and dimension table in banking project?
What are the various reporting tools in the market?
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
whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?
what is object level locking ? where do appear this type of locking ?
Why Multiload does not supports USI and supports NUSI?
How many sessions of MAX is PE capable of handling at a particular time?
Does anyone got Latest TERADATA V12 Certification Dumps for the below? TE0-121 , TE0-122 , TE0-123 , TE0-124 , TE0-125 , TE0-126 TE0-127 , TE0-12Q
Explain and compare pros and cons of snow flake schemas?
Teradata 
