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
- 6541 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
How does hashing happens in teradata?
Why teradata is used?
What is the use of virtual processor connectivity in teradata?
Comment whether bottleneck is an error or not.
Explain PDE.
Highlight the differences between Primary Key and Primary Index.
Explain and compare pros and cons of start schemas?
Explain BYNET.
What is the difference between teradata and basic rdbms?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
List out teradata data types?
What are the uses of client software involved in teradata?
What is meant by a Least Cost Plan?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
how do you manage the production space. what are the proactive methods you can take ?
