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
- 7010 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
Highlight the limitations of TPUMP Utility.
Explain parsing engine in teradata?
What is the opening step in basic teradata query script?
What is primary index and secondary index?
What are the frequently used data types in teradata?
Explain the term 'row' related to relational database management system?
Differentiate primary key and partition key?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What is upsert statement in teradata?
What is the difference between fastload and multiload? Which one is faster?
What are the components used in smp and massively parallel processing (mpp) machines?
How do you see a ddl for an existing table?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Explain how spool space is used.
List out all forms of LOCKS that are available in Teradata.
