Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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


Please Help Members By Posting Answers For Below Questions

What are the components provided on node?

1037


List out some of the primary characteristics of teradata.

983


What are the newly developed features of Teradata?

1016


If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2196


If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1147


What is the difference between union and union all in teradata?

1116


What is the difference between teradata and basic rdbms?

1011


How do you do backup and recovery in teradata?

1011


What is a dimension table?

1054


Why do you get spool space errors? How do trouble-shoot them?

1051


What is the meaning of Caching in Teradata?

1132


Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3369


What happens when a node suffers a downfall?

1120


Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2170


How is MLOAD Client System restarted after execution?

1139