Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ramreddy
Group by is like partition by in OLAP
like tradition group by following having class if we filter (aggregate columns )
Qualify is also functioning like having in OLAP.with partition by class .
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
Explain fastload in teradata?
What are the various indexes in teradata? Why are they preferred?
What is the opening step in basic teradata query script?
What are the multiload utility limitations?
What are the functions involved in shared information architecture?
How can bottlenecks be identified?
What are the steps involved in the process flow of the sql statement through channel attached system?
What are some commonly used bteq scripts?
What are the different methods ot loading a dimension table? A fact table etc?
What are the commands to make a new table, change a table and remove a table in teradata?
What are the various etl tools in the market?
What are the string manipulation operators and functions associated with teradata?
What are the available join types in teradata?
Highlight a few of the advantages that ETL tools have over Teradata.
