Teradata Interview Questions and Answers

All Categories >> Databases Programming >> Teradata >> ▼

Teradata Interview Questions and Answers will guide us now that Teradata is a hardware and software vendor specializing in data warehousing and analytic applications. Teradata was formerly a division of NCR Corporation. Learn more about Teradata by our Teradata Interview Questions with Answers guide

  1. Teradata questions updated at 01 Jul 10 in Category Databases Programming and visited 2193 Times

Teradata Questions and Answers:

1 :: How many codd,s rules are satisfied by teradata database?

11 1/2 codd,s rule is supported by teradata.
3/5 Rating (1 vote)
Is This Answer Correct?    4 Yes 0 No
Place Your Answer

2 :: What is Group by in Select statement?

Group by clause is used in Teradata to remove repetitive values in a column or group of columns, when we select result of a particular query. And it represent it as single entity.
0/5 Rating (0 vote)
Is This Answer Correct?    4 Yes 0 No
Place Your Answer

3 :: What is stored procedure in Teradata?

A stored procedure is a group of SQL statements that form a logical unit and perform a particular task. Stored procedures are used to encapsulate a set of operations or queries to execute on a database server. For example, operations on an employee database (hire, fire, promote, lookup) could be coded as stored procedures executed by application code. Stored procedures can be compiled and executed with different parameters and results, and they may have any combination of input, output, and input/output parameters.
0/5 Rating (0 vote)
Is This Answer Correct?    3 Yes 0 No
Place Your Answer

4 :: Can we have an unconnected lkp to lookup a DB2 record against a Teradata record? doesnt seem to work. I could be wrong.

Yes we can but some times we need to check the value which lookup is returning like it happens in teradata if we are having lookup on varchar column and record is coming from source system it never works because when informatica creates cache from there it adds space to the values.so we always have to use ltrim(rtrim)) function in lookup query.
0/5 Rating (0 vote)
Is This Answer Correct?    0 Yes 0 No
Place Your Answer

5 :: What is the difference between start schma and Fsldm?

FSLDM --> Financial Services Logical Data Model (Teradata FS-LDM 7.0) its developed by Teradata for the financial sectors (Speciafially for Bank). it can be customised based on the user requirement.

StarSchma --> Its a relational database schema for representing multidimensional data. The data is stored in a central fact table, with one or more tables holding information on each dimension.

So both are entirely different.......
0/5 Rating (0 vote)
Is This Answer Correct?    0 Yes 0 No
Place Your Answer

Rate This Category:
3/5 Rating (2 votes)
 Place Your Question



Top: Teradata Interview Questions and Answers
Teradata Interview Questions and Answers

Top Frequently Asked Teradata Question
Frequently Asked Teradata Job Interview Question


Top Frequently opened Databases Programming Job Interview categories
Most popular Databases Programming Job Interview categories

Comments About Teradata Interview Questions and Answers

Share your valuable opinions, ideas and suggestions about Teradata Interview Questions and Answers
While placing your comment your email address is required but won't be published any where else; Personal information will be kept confidential; we do not sell or release our respective visitors private information.

  1. Webmaster 23rd of May 2012

    Webmaster Said

    Tell us what you feel about Teradata Interview Questions and Answers
    All comments will be published after review. No login or registration is required to post a comment on Teradata Interview Questions and Answers We offer and invite you to submit your valuable comment now; Please be respectful of others when commenting. Insulting others, self-promotional comments, website promotional comments, marketing stuff, SEO Techniques, SMS-style content and off-topic comments will not be approved at this information portal.
    So start sharing your thoughts regarding Teradata Interview Questions and Answers
    Thank you.

    Reply

Leave a Comment

Leave a Comment
  4.  Enter This Verification Code  Regenerate Verification Code  



Your reply will be added to the comment above (Below any other replies to this comment) -

Top Comments About: Teradata Interview Questions and Answers
Comments on Teradata Interview Questions and Answers

 
Top of Link batk to Teradata Interview Questions and Answers
Link batk to Teradata Interview Questions and Answers

Privacy Policy | Terms and Conditions | Contact Us »