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
- 7048 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
What is the purpose of joins in teradata?
When tpump is used instead of multiload?
In Teradata, what is the significance of UPSERT command?
What is called partitioned primary index (ppi)?
What is partitioned primary index (ppi)?
what is object level locking ? where do appear this type of locking ?
Explain the meaning of Amp?
What are the scenarios in which full table scans occurs?
what is sysdba and sysdbc ? which has high priority ?
Highlight a few of the advantages that ETL tools have over Teradata.
What are the functions of a Parser?
What are the components provided on node?
Explain teradata utilities?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What is oltp?
