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

Cap Gemini Teradata Interview Questions
Questions Answers Views Company eMail

What is the diffrence between Multiload & Fastload interms of Performance?

8 37108

What are the types of tables in Teradata

22 59956

id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my to change Gender Male to Female & Female to Male??? Write sql query for this question???

6 9030

IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process it is taking that sql from the system????? thanks in Advance

2 5843

what happen if a query fail in dispatcher?

1 5634

what is the structure of UV table in MLOAD?

4 12447

Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance

6 9239

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 8483

I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.

4 9517

Post New Cap Gemini Teradata Interview Questions

Cap Gemini Teradata Interview Questions

Un-Answered Questions

Who was the creator of c++?


What are dynamic and static resources?


Have you ever been involved in Testing?


Tell me a scenario where did you use secondary index?


You are a project manager for Capella Systems. Your company writes custom software for accounting and financial systems for medium- to large-sized corporations. Your recent project has experienced some setbacks, and you've been forced to rework the design of one of the programs because it doesn't match the customer's requirements. Since some parts of the program have already been written, it will have to be rewritten so that it matches the design changes. This rework has increased costs, and you're beginning to notice some signs of poor morale because of the rework. Which of the following is true? A. The problems occurred because the WBS was not constructed properly. B. The quality assurance plan was carried out correctly, which is how the design problems were discovered. C. The problems occurred as a result of poor scope definition. D. The Risk Management Planning process details these kinds of risks and the responses you should put into place should they occur.


Does swift support multiple inheritance?


How can I prevent another program from modifying part of a file that I am modifying?


Define blouson?


How do I find duplicates in two columns?


What was a challenging problem you had to solve and how did you solve it?


What is the command syntax that tells you whether you are on the master server or not? And how many master does mongodb allow?


1) SORT FIELDS=(20,4,CH,D,10,3,CH,D) OUTREC FIELDS=(7:20,4,C' FUTURE ',20,2,10,3,1Z,1,9,13,7, 24,57,TRAN=LTOU,6X'FF') This example illustrates how a fixed-length input data set can be sorted and reformatted for output. The SORTIN LRECL is 80 bytes. The reformatted output records are fixed length with a record size of 103 bytes. SOLRF (the IBM-supplied default) is in effect, so unless the SORTOUT LRECL is specified or available, it will automatically be set to the reformatted record length of 103. in the above example i have some doubts that a) sort fields=(20,4,CH,D,10,3,CH,D) -what exactly it does and this fields related to output record fields or input record fields b)outrec used to refprmat the records after sorting that means could please reply me as soon as possible Thanks. Venkat


What are zymogens?


What are the data structures used in RDBMS, Network data model & Hierarchical data model?


explain construction of lvdt?