Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z




IBM Teradata Interview Questions
Questions Answers Views Company eMail

can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

1 6142

In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?

2 9312

What is FILLER command in Teradata?

9 22459

How to find No. of Records present in Each AMP or a Node for a given Table through SQL?

2 12420

Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?

9 29182





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

4 20130

I have all the TERADATA Certification Dumps for the below: NR0-011, NR0-012, NR0-013, NR0-014 NR0-015 NR0-016, NR0-017 If anyone need it, pls drop me a mail with Code in the mail to: terashish@gmail.com

199 109305

why varchar takes 2 extra bytes?

4 10305

Where we use PPI in real time??? What is the disadvantages of PPI?

3 6932

Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?

2 6446

What is differnce between Error code and Error Level in Bteq

6 29812

Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table

6 13920

What is the default join strategy in Teradata???

5 19633

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?

974

in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that

1 3566

Post New IBM Teradata Interview Questions



Un-Answered Questions

Short Answer on _____________Accident Insurance

675


THICK ETHERNET IS USED IN

1573


what is the difference between vat return and return for remittance on value added tax.

1404


ER-5 & ER- 7 ER -4 related all information 1) What Fill The ER-5 & ER- 7 ER -4 2) What Infomation Fill In the return

865


distribution transformer de-rating formula on over limit iron losses  

1055






what's the difference between 'shaft power demand' and 'BHP' , when we consider electrical load list.

368


Topics: Structures, Arrays, Searching and Sorting Assume there is a small mobile computer device including a hard disk and a slot for a memory card. The device shall be used to backup photos e.g. during holiday. Every time a memory card is connected all photos of the card are copied into a new folder automatically. And your task is to develop some basic controlling software to show, add, remove, search and sort the directories of photos. Step by Step Implementation 1.Define two symbolic constants, one to hold the total volume of the disk (e.g. VOLUME) and another one to hold the number of entries the files system of the device can handle (MAXFOLD). 2.Define a new structure data type named DATE to store a date consisting of year, month and day as unsigned values. 3.Define an other structure data type FOLDER to store the information of one folder of photos: ◦A title as character array of appropriate length ◦The location (event) the photos are taken as character array of appropriate length ◦The date of the day the photos are copied to the disk using the just defined data type DATE ◦The number of photos as natural number ◦And the size of the folder in MB as floating point value 4.Define the following global variables and initialise them: ◦disk as an array with MAXFOLD elements of data type FOLDER ◦folders as natural value to count the number of folders currently stored at the disk (valid elements in the array) TEST: Now you should be able to compile the code the first time without any warning or error. In the menu only "p" to print and "q" to quit will work!. 5.Now complete the functions given by their prototype: float freeSpace ();The function has to calculate the sum of the size component of all elements currently stored in the disk array. The function shall return the free space of the disk by the difference between the available total volume and the calculated sum. TEST: To test this function you only need to uncomment printing the "statusline" at the function actionmenu(). Compare the calculated value with a manual calculation of the example values given above. unsigned isBefore (DATE, DATE);The function checks if one date is before the other. There are 3 different possibilities which have to be handled. Imagine for example these 3 different combinations of values: ◦2010-01-01 : 2010-01-02 ◦2010-01-01 : 2010-02-01 ◦2010-01-01 : 2009-01-01 The function shall just return the result of the comparison. unsigned isEqual (DATE, DATE);The function checks if one date is equal to the other, all components have to be compared. The function shall just return the result of the comparison. int findByDate (DATE);As the array is should be kept in order (sorted by date) implement a binary search for a folder by its date here. You need only to adapt the binary search we used in the exercise. Use the 2 comparing functions above where appropriate. The function shall return the index of the element which was found or -1. TEST: Now you can try searching a folder by date via the "s" in the menu. Activate the corresponding part in the main function. int isSpaceLeft (FOLDER);This function compares the free space of the disk with the size of folder given with the parameter list. The function shall return 1 if there is enough space to add the folder, otherwise 0 (just the result of the comparison). void SortByDate ();This function shall implement the InsertionSort using the component date as key. Use the provided algorithm/souce code of the exercise as template. If you need a comparison between dates, use the function isBefore you have written again. void addFolder (FOLDER);The function has to check if the disk has additional capacities to add the new folder (number of folders and space left). If at least one of these conditions is false print an error message and return -1. Else there has to be added an other test to avoid 2 folder elements with the same date (use the findByDate function here. If there is no folder with the new date simply attach the new folder at the end of the array and call the sorting algorithm afterwards to keep the order in the array. TEST: Now you can try to add a folder via the "a" in the menu. Activate the corresponding part in the main function. void delDir (int);This function removes one element of the disk array. The input parameter contains the index of the element to delete. Deletion can simply be done by moving all elements at the right one to the left (overwriting the element to delete. The function may get a -1. This has to be checked first (certainly there is nothing to delete then!) Don't forget to decrement the counter of elements at the end. TEST: Now you can try to remove a folder by date via the "r" in the menu. Activate the corresponding part in the main function. unsigned findAllOfLocation(char[], FOLDER[]);This is an optional additional task: The function shall find all elements with the given value for the component location (first input parameter). The array elements which are found have to be added to the FOLDER array (second input parameter). As this parameter is an array we can use the result later in the main function. There kernel of function implements a modified linear search on the disk array (it does not stop if one element is found bat continues search until the location of all elements is checked). The finally function shall return the number of elements found in the disk array. TEST: Now you can try to add a folder by date via the "l" in the menu. Activate the corresponding part in the main function.

1341


How to write a test cases for the following Please it is urgent Once user clicks that link Invite Friend page opens up thru which user can do 2 functions - first is to search friends detail(name, mail id) from her address book in other sites (india times, yahoo, gmail and rediff) and second to mail the invite to the selected person/s. User can send invite to multiple person at same time. Searching friends detail in other address books will work like this: - User will input name, email id, pwd etc, select from which site she want to get friends list and then click on Import. - Users address book from other sites will be imported in one shot(first time) to iDiva database. - It will be arranged in alphabetical order(complete list) and mail ids which are already used will be in different color. - User will be able to update her address book by clicking on ""Refresh"" button on the page, which will trigger the process again, and fetch new mail ids.

1467


how the speed of the gets motor regulated. does it draw the same current on the all speed level.

831


Can I Get A Credit Card After Bankruptcy?

6


What do you like in your previous Sales Job? What sales challenge have you experienced recently?

557


What is SHS?

2


can any working guy help me...by explaining me about any twop reports which u have created.....on sales and purchase

1131


what are the areas of improvement required in yourself to achieve your career goals? Describe what you are doing/plan to do to address the areas of improvement

2435


What measures can be taken from rural development?

5






IBM Teradata Interview Questions
  • Software (1)
  • C (84)
  • OOPS (37)
  • C++ General (9)
  • MFC (2)
  • COM DCOM (1)
  • VC++ AllOther (1)
  • Delphi (11)
  • PHP (16)
  • Programming Languages AllOther (31)
  • ASP (5)
  • CGI Perl (7)
  • JavaScript (6)
  • VB Script (15)
  • JSP (6)
  • Shell Script (6)
  • AJAX (1)
  • Ruby on Rails (1)
  • Scripts AllOther (2)
  • SNMP (1)
  • TCP IP (10)
  • UDP (1)
  • Protocols AllOther (3)
  • Networking Administration (28)
  • Networking Security (3)
  • Networking AllOther (9)
  • Visual Basic (5)
  • C Sharp (36)
  • ASP.NET (37)
  • VB.NET (3)
  • ADO.NET (11)
  • IIS (9)
  • Crystal Reports (3)
  • BizTalk (3)
  • Dot Net Framework (14)
  • Dot Net WindowsForms (2)
  • Dot Net General (3)
  • Dot Net AllOther (4)
  • Exchange Server (12)
  • Microsoft Related AllOther (2)
  • Oracle General (39)
  • Architecture (1)
  • Database Management (11)
  • Forms Reports (7)
  • Oracle AllOther (9)
  • SQL Server (68)
  • MySQL (3)
  • DB Architecture (1)
  • DB Administration (11)
  • DB Development (9)
  • SQL PLSQL (41)
  • Databases AllOther (7)
  • Windows (3)
  • Windows Threads (2)
  • Windows General (6)
  • Windows AllOther (26)
  • Linux Commands (18)
  • Linux Threads (2)
  • Linux IPC (2)
  • Linux Socket Programming (1)
  • Linux System Calls (5)
  • Linux General (3)
  • Linux AllOther (20)
  • Unix Commands (33)
  • Unix IPC (3)
  • Unix Socket Programming (1)
  • Unix General (5)
  • Unix AllOther (11)
  • Solaris Commands (30)
  • Solaris Threads (3)
  • Solaris System Calls (2)
  • Solaris General (10)
  • Solaris AllOther (82)
  • Operating Systems General Concepts (17)
  • Data Structures (1)
  • Operating Systems AllOther (13)
  • WinRunner (10)
  • Load Runner (28)
  • QTP (176)
  • Test Director (3)
  • Rational TestSuite (4)
  • Silk Test (9)
  • Selenium (1)
  • Automation Testing AllOther (10)
  • Manual Testing (279)
  • QA Concepts (23)
  • Mobile Testing (3)
  • Test Cases (21)
  • Test Documents Reporting (2)
  • Testing AllOther (12)
  • Apache (1)
  • Servers AllOther (6)
  • COBOL (139)
  • JCL (134)
  • CICS (34)
  • DB2 (84)
  • IMS (11)
  • IDMS (1)
  • Natural (6)
  • Assembler (1)
  • QMF (2)
  • MVS (2)
  • OS390 (2)
  • VSAM (11)
  • Sysplex (1)
  • IBM MainFrame AllOther (40)
  • RPG400 (59)
  • DB400 (3)
  • COOLPLEX (1)
  • IBM AS400 AllOther (49)
  • IBM PL/1 (1)
  • Core Java (77)
  • Advanced Java (7)
  • Swing (2)
  • EJB (4)
  • Servlets (17)
  • Struts (16)
  • JDBC (11)
  • JMS (2)
  • SunOne (1)
  • J2EE (3)
  • Weblogic (30)
  • Websphere (7)
  • Java J2EE AllOther (6)
  • J2ME (1)
  • Java Related AllOther (4)
  • MQSeries (16)
  • Middleware AllOther (10)
  • HTML DHTML (3)
  • XML XSLT RSS (6)
  • Flash Action Scripting (1)
  • SOAP (1)
  • Web Related AllOther (2)
  • Teradata (42)
  • Business Objects (66)
  • Cognos (171)
  • Informatica (179)
  • Actuate (3)
  • Ab Initio (56)
  • Data Stage (147)
  • SAS (5)
  • Micro Strategy (3)
  • ETL (12)
  • Data Warehouse General (25)
  • HR Questions (24)
  • Design Patterns (6)
  • Requirements Management (1)
  • Project Planning (2)
  • Project Management (2)
  • Software Design AllOther (2)
  • CTC (1)
  • Debugging AllOther (3)
  • Clear Case (10)
  • Version Control AllOther (1)
  • Vi Editor (1)
  • Telecom Protocols (1)
  • ISDN (2)
  • Telecom General (2)
  • SAP Basis (168)
  • SAP ABAP (300)
  • SAPScript (13)
  • SAP SD (310)
  • SAP MM (56)
  • SAP QM (4)
  • SAP PP (34)
  • SAP PM (6)
  • SAP PS (1)
  • SAP FI CO (262)
  • SAP HR (32)
  • SAP CRM (37)
  • SAP SRM (2)
  • SAP APO (2)
  • SAP Business Warehouse (29)
  • SAP Security (159)
  • SAP Interfaces (2)
  • SAP Netweaver (22)
  • SAP ALE IDocs (8)
  • SAP B1 (16)
  • SAP GTS (1)
  • SAP AllOther (11)
  • CRM General (7)
  • Siebel (55)
  • ERP General (3)
  • Oracle Apps Technical (53)
  • Oracle Apps Financial (74)
  • Oracle Apps HRMS (6)
  • Oracle Apps CRM (1)
  • Oracle Apps SCM (10)
  • Oracle Apps AllOther (1)
  • ERP CRM AllOther (1)
  • VLSI (4)
  • Client Server General (4)
  • AI Algorithms (1)
  • AI AllOther (1)
  • Cryptography Algorithms (1)
  • WebMethods (16)
  • TIBCO (18)
  • BPM (1)
  • EAI AllOther (1)
  • Visual Effects (1)
  • Requirement Management (5)
  • Risk Analysis (6)
  • Estimation Analysis (4)
  • Planning & Integration (4)
  • Software Quality Analysis (3)
  • Software Integration & Release (1)
  • Program Management (4)
  • Apache Hadoop (1)
  • Pega (10)
  • Micro Biology (1)
  • Bio Informatics (1)
  • Nuclear Physics (1)
  • Organic Chemistry (1)
  • Health Pharma AllOther (1)
  • Civil Engineering (3)
  • Mechanical Engineering (8)
  • Electrical Engineering (40)
  • Electronics Communications (27)
  • Chemical Engineering (2)
  • Instrumentation (4)
  • Engineering AllOther (17)
  • Business Administration (11)
  • Marketing Sales (14)
  • Banking Finance (41)
  • Human Resources (17)
  • Personnel Management (1)
  • IT Management (5)
  • Non Technical (3)
  • Business Management AllOther (12)
  • Audit (5)
  • CompanyAffairs CS (3)
  • Taxation (21)
  • Accounting General (58)
  • Accounting AllOther (93)
  • Call Centre AllOther (289)
  • Government (1)
  • UPSC General Studies (3)
  • UPSC AllOther (3)
  • SSC General Science (1)
  • SSC General Studies (6)
  • RRB (4)
  • POs (2)
  • BSRB Clerical (2)
  • Group I (4)
  • Group II History (3)
  • Group II AllOther (2)
  • Group II Political Science (1)
  • General Studies (2)
  • APPSC AllOther (10)
  • General Knowledge_Current Affairs (19)
  • Government AllOther (2)
  • Teaching (1)
  • Funny Interview Questions (5)
  • Everything Else AllOther (13)
  • English (12)
  • General Aptitude (98)
  • Puzzles (6)
  • Placement Papers (22)
  • CCNA (42)
  • CCDA (1)
  • Microsoft Certifications (6)
  • Sun Certifications (6)
  • CISA Certification (2)
  • Oracle Certifications (5)
  • ISTQB Certification (5)
  • Certifications AllOther (6)
  • H1B Visa (3)
  • USA Student Visa F1 Visa (5)
  • L1 Visa (4)
  • USA Immigration Visa (1)
  • USA Business Visa B1 Visa (2)
  • USA Dependent Visa H4 Visa (2)
  • USA AllOther Visa (2)
  • UK Visa (1)
  • Australia Visa (1)
  • Canada Visa (3)
  • C Code (8)
  • C++ Code (7)
  • J2SE Code (2)
  • J2EE Code (2)
  • C Sharp Code (1)
  • ADO.NET Code (1)
  • JSP Code (1)
  • GATE (3)
  • IIT JEE (1)
  • CAT (1)
  • OPENMAT (1)
  • ICET (2)
  • Oracle Errors (14)
  • SQLServer Errors (1)
  • Scripts Errors (2)