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.
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 do you determine the number of sessions?
What are the steps to create a data model?
What is basic teradata query language?
What are the updated features of teradata?
What is meant by a Highest Cost Plan?
what are the day to day activities of teradata DBA ?
Explain BYNET.
What are different table types used in teradata?
What is the difference between teradata and basic rdbms?
What are default access rights in teradata?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
How would you load a very large file in teradata in general?
Explain some differences between mpp and smp?
How many sessions of MAX is PE capable of handling at a particular time?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.