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

What does Amp contain and what are all the operations that it performs?

0 Answers  

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

0 Answers  

How to run a query in teradata?

0 Answers  

Describe primary index in teradata. And what are the available primary index types?

0 Answers  

Explain about Skew Factor?

6 Answers   TCS,

If the script is aborted. why it is aborted and how can you identify ?

1 Answers  

If table have access lock.In the same table write lock is posible or not?

1 Answers  

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

0 Answers   IBM,

Explain the most common data types used in teradata?

0 Answers  

In the Primary Index, what is the score of AMPs that are actively involved?

0 Answers  

in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?

2 Answers   HCL,

How is Teradata in current market?

4 Answers  

For more Teradata Interview Questions Click Here
Categories