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

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

0 Answers  

Explain teradata vs. Redshift?

0 Answers  

What is called partitioned primary index (ppi)?

0 Answers  

What is meant by a Highest Cost Plan?

0 Answers  

What is the Maximum number of volatile tables that can be created?

4 Answers   Mphasis,

Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?

4 Answers  

What happens when a node suffers a downfall?

0 Answers  

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

0 Answers  

Why Multiload does not supports USI and supports NUSI?

4 Answers  

What is teradata and why it is used?

0 Answers  

How can we load single row of data into teradata database. please give me the process.

3 Answers  

What is collect statistics?

0 Answers  

For more Teradata Interview Questions Click Here
Categories