Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


1. generally how many node system will be used by the client.
2. while running mload if the job is aborted/failed at any
phase what we have to look after to run the job successfully?
3.i wanted to know how to write the fastload script for
table creation as well as table loading in a single script?

Answers were Sorted based on User's Feedback



1. generally how many node system will be used by the client. 2. while running mload if the job is ..

Answer / ugandhar

1) It depends on the requirement. Generally around 10 node
system will be a moderate to high dataware house
environments.
2) Check the log file to know the exact failure. Fix it, do
the mlod cleanup and rerun the job.
3) specify the table craetion step in the beginning of the
script before the actual fastload commands starts.

Is This Answer Correct ?    8 Yes 0 No

1. generally how many node system will be used by the client. 2. while running mload if the job is ..

Answer / yuvaevergreen

1. As said above, the requirement drives the no of nodes to
be connected. But, for millions of data, generally, 10 nodes
may be used
2.release mload, drop the log table,work table,error table
and submit the mload if the table needs to be loaded from first.
3.Log onto Teradata,Defining the Teradata table that you
want to load (target table),Defining the INPUT data file,
Telling the system to start loading.

Is This Answer Correct ?    2 Yes 0 No

1. generally how many node system will be used by the client. 2. while running mload if the job is ..

Answer / tdguy

1. Depends on the requirement and budget.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer



More Teradata Interview Questions

What is the default join strategy in Teradata???

5 Answers   IBM,


"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me

9 Answers  


What is oltp?

0 Answers  


what is the default character set in teradata,,?

2 Answers   IBM, TCS,


What is the purpose of indexes?

0 Answers  






what is identity columns in teradata

2 Answers   Wipro,


In Teradata, what is the significance of UPSERT command?

0 Answers  


What are the various reporting tools in the market?

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,


How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?

4 Answers   Comsys, IBM,


What are the different softwares used with their functions in teradata?

0 Answers  


Does any body has TERADATA Certification Dumps, if any body is having please let me know to summee4you@gmail.o, it is very Very URGENT to me

25 Answers   TCS,






Categories