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 are the steps involved after the disk manager passes the request?

0 Answers  

Write a program to show the parser component used in teradata?

0 Answers  

What is basic teradata query language?

0 Answers  

What is multi insert?

0 Answers  

Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR

4 Answers   Cap Gemini,

1.what is activity count? 2.what is skew factor? how it's working explain brefily

5 Answers   Satyam,

What are the multiload utility limitations?

0 Answers  

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

0 Answers  

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

1 Answers  

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

0 Answers  

if collect stats but it show low confidence why?

0 Answers   IBM,

How is MLOAD Client System restarted after execution?

0 Answers  

For more Teradata Interview Questions Click Here
Categories