Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.
1 3527How to resolve the error "WER488A JOIN CAPACITY EXCEEDED" I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem? I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem?
1 7613Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --
5 6448Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974
5 9813hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq
IBM,
25251.How to apply sorting to Crosstab report? If so please give me example? 2.How to create Report level Joins?explain with example?
2 7314
Define Expression
What's new in angular 8?
Can we place an excel file in a shared location and and use it to develop a report and refresh it in regular intervals?
Which Amazon leadership principle do you resonate most with?
How to add custom color to tableau?
What is a service angular?
What is the difference between translational and elaborational approaches?
How do I change file associations in windows?
Explain a bit about your family background and yourself?
What are the functions to open and close the file in c language?
Why data cleaning plays a vital role in analysis?
How would you define architecture?
how can we describe comp sync?
What does debug script mean?
What are steps to create an attribute view?