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...

  1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

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.

Question Posted / naveen.d135

Answers were Sorted based on User's Feedback



We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year w..

Answer / tdguy

PPI can be a better option. Using PPI, data can be
partitioned using months also.

Is This Answer Correct ?    2 Yes 0 No

We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year w..

Answer / 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

More Teradata Interview Questions

How is MLOAD Teradata Server restarted after execution?

0 Answers  

What are the joins in teradata and how many types of joins are there in teradata?

0 Answers  

What is the purpose of joins in teradata and what are the available join types?

0 Answers  

Can we Suggest as how is the process to get a job in teradata in current market??Is it easier???

1 Answers   IBM,

How do you create tables? Exact syntax, and create profiles, users in teradata?

0 Answers  

Why MLOAD needs Work Tables?

5 Answers   Teradata,

What's the difference between timestamp (0) and timestamp (6)?

0 Answers  

Explain fastload in teradata?

0 Answers  

Explain the new features of teradata?

0 Answers  

Why Multiload does not supports USI and supports NUSI?

4 Answers  

What is a level of granularity of a fact table?

0 Answers  

what is the query for retrieve the unique values(not display the duplicates values) from single table?

6 Answers   IBM,

For more Teradata Interview Questions Click Here
Categories