-
-
ODBC - CLI configuration in TERADATA
How do we configure ODBC and CLI in TERADATA systems.
-
Teradata Versions
What are the difference between Teraadata Versions?
-
-
How can we build data marts from FSLDM. is there any standard approach for this? Is FSLDM supports place holder for aggregated data?
gopi.mainframe
- Jul 26th, 2008
Here DM is a Subject oriented small data warehouse. It pics all the data from the HISTORICAL DATA WAREHOUSE IS OLAP.
-
How teradata makes sure that there are no duplicate rows being inserted when its a SET table?
Teradata will redirect the new inserted row as per its PI to the target AMP (on the basis of its row hash value), and if it find same row hash value in that AMP (hash synonyms) then it start comparing the whole row, and find out if duplicate.If its a duplicate it silently skips it without throwing any error.Cheers,Shilpa
saurabh.gupta4u
- Feb 6th, 2009
When the target table has UPI then the Row hash of PI column will lead to the AMP and the duplicate row is rejected with an error.In case of a NUPI defined on a SET table the duplicate row is compared on all columns and if the entire row is dups then it is rejected without an error code > 0.
-
SPOOL Process Error Types
How many types errors will be occur in total SPOOL process How will you connect a database server to other server?
developer_veni
- Jul 26th, 2009
We can connect from one server to another server in UNIX using the commandssh or FTP or SUssh -?ssh user_id@server_name
-
Teradata Optimization and Performance Tuning
What is optimization and performance tuning and How does it work in practical projects. Explain with an example.
asshu18
- Apr 14th, 2009
Optimization is the technique of selecting the least expensive plan (fastest plan) for the query to fetch results. Optimization is directly proportional to the availibility of --1. CPU resources 2. Sy...
-
EXCEPT and MINUS
What is the difference between EXCEPT and MINUS operator in Teradata SQL?
Abhilash AS
- Jan 11th, 2011
EXCEPT is ANSI Compliant and MINUS is Teradata specific. Function wise both are same.
-
Teradata versions
How many version is there in Teradata? please give me detail information for version ? Version Name and Particular date ?
-
What is a common data source for the central enterprise data warehouse?
Operational data stores
-
Which two can be implemented as a centrally located logical architecture?
è operational data storeè logical data mart
Imad
- Aug 15th, 2006
1- Logical Data Mart Repository2- Provides a single version of the truth
-
What is the difference between start schma and Fsldm?
Rajendran77
- Feb 24th, 2006
FSLDM --> Financial Services Logical Data Model (FS-LDM). Its a Teradata standard product for Financial Sector (Specifically for Banks). It can be customized based on the user requirements.S...
rajendran
- Feb 24th, 2006
Hi there, 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 ...
-
What is the purpose of Before Journal and After journal?
yuvaevergreen
- Jun 7th, 2011
Before Journal keeps the images of the table before making the change to the table. Very useful, if the changes need to be reverted incase of a fault or rollback. After Journal keeps the images of the table after the changes has been made to the table.
SanthuTeradata
- Mar 30th, 2011
We use both before journal and after journal in Permenent journal to do selective or full recovery of data..........consider Today Monday**Yesterday--------->Before ImageTuesday------------>Afte...
-
-
After creating tables dynamically in the Teardata, where is the GRANT table option usually done ? When tables are newly created, what is the default role and what the default privileges which get assigned ?
girishnayak
- Jun 27th, 2009
The default previleges being assigned to a creator are as belowRUDRSDGCGIXDPDTRFI
Neelima Dahi
- Aug 10th, 2007
The GRANT option for any particular table depends on the privilages of the user. If it is an admin user you can grant privilages at any point of time.The deafult roles associated with the newly created tables depend on he schema in which they are created.
-
What are the enhanced features in Teradata V2R5 and V2R6?
shams756
- Nov 2nd, 2012
V2R6 FEATURES
1. Queue Tables are added.
2. Triggered Stored Procedure added.
3. Stored Procedure Grammar Merge added.
4. Multi statements request submitted (supported in stored
procedures by using
BEGIN REQUEST
------
END RESQUEST.
navneet_iway
- Jun 11th, 2008
V2R6 included the feature of replica in it.in which copy of data base are available on another system.meam V2R6 provide the additional data protaction as comprison to V2R5 while if data from one system has been vanishes.
-
Vertical & Horizontal Partitioning, Join & Hash Indexes and PPI?
What are the differences between the followings?- Vertical & Horizontal Partitioningvs- Join & Hash Indexes vs- PPI
-
Low and High Confidentiality
Explain What are Low and High Confidentiality in Explain command.
yuvaevergreen
- Aug 13th, 2010
The explain generally displays the plan which would be prepared by Optimizer. We can say that(though not accurate), plan would be the steps followed by Teradata to solve a query. Confidence levels ind...
samyukta.mogadali
- Jul 28th, 2010
Low Confidence: Normally when stats are difficult to use preciselyHigh Confidence: Normally Optimizer is sure of the results based on the stats available
-
Skewness
How will you avoid Skewness?
arunFERGY
- May 25th, 2017
Unequal distribution of data on amps is called skewness. Choose PI columns as unique as possible to avoid this.
debojitpal
- Feb 1st, 2011
Data or Amp skew occurs in teradata due to uneven distribution of data accross all the amps. Often, this leads to spool space error too. To avoid skewness, try to select a Primary Index which has as m...
Teradata Interview Questions
Ans