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.

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  


Categories