Answer Posted / nitin bansal
Group by is used to find an aggregate like SUM or count for
a group of values. Where as Qualify is used like the having
clause on functions like RANK.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are aggregate tables? How do you design them using teradata?
how many modules are there in telecome domain?how to explain the architecture?
What is the command in bteq to check for session settings ?
If a Node is busy what are the steps you can take to avoid ?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Explain some differences between mpp and smp?
What are the different methods ot loading a dimension table? A fact table etc?
What are the uses of bynets in multi-node systems?
Explain vproc in teradata?
How would you load a very large file in teradata in general?
What do you mean by caching in teradata?
What are differences between teradata and ansi session modes in teradata?
what is object level locking ? where do appear this type of locking ?
Highlight the points of differences between the database and user in Teradata.
What is the difference between fastload and multiload?