Sign Up Login


  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 is the syntax for case when statement?

0 Answers  

I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata

3 Answers   Wipro,

What is the command in bteq to check for session settings ?

0 Answers  

How is MLOAD Client System restarted after execution?

0 Answers  

How would you load a very large file in teradata in general? What utility would you use for it? Why?

0 Answers  

can we join volatile table with general table an global temporary table with general table ?

4 Answers   IBM,

What are the advantages of teradata?

0 Answers  

I WANT TO LEARN TERA-DATA ,SO CAN ANY BODY PLZ REFER WHAT ARE THE TOPICS I HAVE TO GO THROUGH, TO GET ASAP JOB ,SO PLZ REFER ME WHERE I CAN GET NICE COACHING ON TERADATA.

13 Answers  

how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer

2 Answers   IBM,

What are the available primary index types?

0 Answers  

what is the structure of UV table in MLOAD?

4 Answers   Cap Gemini,

Why are oltp database designs not generally a good idea for a data warehouse?

0 Answers  

For more Teradata Interview Questions Click Here
Categories