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
What is the difference between global temporary tables and volatile temporary tables?
Why managing the data is important?
Explain how spool space is used.
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
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
What are the scenarios in which full table scans occurs?
In Teradata, what is the significance of UPSERT command?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What is the difference between fastload and multiload? Which one is faster?
what are the day to day activities of teradata DBA ?
Why teradata is used?
What are the joins in teradata?
How to load specific no.of records using bteq, or fastload,or multiload
What is meant by a Parsing Engine?
What is basic teradata query language?