Interested to Buy Any Domain ? << Click Here >> for more details...
We are migrating an oracle table into teradata, the volume
of data is huge and partitioned (year wise list partition).
How do i simulate the same in teradata.
- 2 Answers
- 7131 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rkraju
>>> do the partition in teradata as per ur bussiness req.use
Tpt export to export the data from oracle to flatfile.use
multiload to load the flatfile data to table.do year wise
exports and imports if data is huge.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which is more efficient group by or distinct to find duplicates?
How to view every column and the columns contained in indexes in teradata?
What is a clique?
What is the purpose of using case expression in teradata?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What is partitioned primary index (ppi)?
How many types of joins are there in teradata?
if collect stats but it show low confidence why?
Explain and compare pros and cons of start schemas?
How do you set the session mode parameters in bteq?
What is the meaning of Caching in Teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What are the joins in teradata and how many types of joins are there in teradata?
Write a program to show the parser component used in teradata?
What are types of partition primary index (ppi) in teradata?
