yes

HI friend please send me teradata dumps.

my email id is kiran_teradata@Ymail.com

Thanks

hi ashish,

         kindly drop me the teradata dumps you have.

          do me the needfull

 thanks & regards

Hi Can you please mail teradata cerfification dump NR0-011 to 
my mail Sky_ckt@yahoo.com

hi ashish,

         kindly drop me the teradata dumps you have to
myblog1907@gmail.com

          do me the needfull

 thanks & regards

Yes i have all TERADATA Certification Dumps, i purchased it 
from US Based website, if you want to share my Dumps drop 
me a mail to: shruthika.mba@gmail.com

shruthika, Can you pls also share the Dumps with me at 
cbandi1@gmail.com. Thanks a lot.

We can find the information of all the indexes in the 
system table "dbc.indices"

JOIN INDEX:
-----------

Join Index is nothing but pre-joining 2 or more tables or
views which are commonly joined in order to reduce the
joining overhead.
So teradata uses the join index instead of resolving the
joins in the participating base tables.
They increase the efficiency and performance of join queries.
They can have different primary indexes than the base tables
and also are automatically updated as and when the base rows
are updated. they can have repeating values.

There are 3 types of join indexes:
1)Single table join index - here the rows are distributed  
based on the foreign key hash value of the base table.
2) Multi table join index - joining two tables.
3) Aggregate join index - performing the aggregates but only
sum and count.

One need have atleast a unique column such as timestamp col 
(and assumption is to keep lowest tmpstmp) OR some  key col 
say IPID (again keep lowest value)..

One determined - Have a nested Select on all rows (except 
that key col) with group by rest of the columns + having 
count(*) > 0 + aggreate MIN(key_col).

    Now said that, have another outer SEL on all columsn & 
do a inner join with above nested Sel .. WHERE outer 
key_col <> MIN value of nested SEL..

See if it works..

Nested query method might be required in other databases 
how ever in TD we don’t need to follow such a difficult way 
to just find out the unique rows. 

In TD we have functions like Rank () and Rownum() in the 
combination of Qualify, helps you to select out the rows  
which you wants to delete.
 
you can add a condition like ‘Where Rank() > 1’

Query to find duplicates in a table:(Custname, Prod, 
Order_amt)

select custname,count(*) from sales1 a where a.rowid > ANY 
(select b.rowid from sales1 b where a.custname=b.custname 
and a.prod=b.prod and a.order_amt=b.order_amt) group by 
custname;

Query to delete duplicates:

delete from sales1 a where a.rowid > ANY (select b.rowid 
from sales1 b where a.custname=b.custname and a.prod=b.prod 
and a.order_amt=b.order_amt);

guys rowid concept is discontinued in teradata as far as my
knowledge goes, we can always use below sql ...

INSERT INTO nodupes_table ( all_columns )
     SELECT all_columns
     FROM dupes_table
     QUALIFY ...

where the QUALIFY ... can be (depending on your version):
     /* V2R5 syntax */
     QUALIFY ROW_NUMBER() OVER (PARTITION BY all_columns
ORDER BY all_columns) = 1

     /* or V2R4 and higher equivalent functionality */
     GROUP BY all_columns
     QUALIFY CSUM(1, all_columns ) = 1

     /* or, alternative OLAP SUM V2R4 and higher syntax */
     QUALIFY SUM(1) OVER (PARTITION BY all_columns ORDER BY
all_columns ROWS
     UNBOUNDED PRECEDING ) = 1


I do think an insert-select into a set table would be a
cleaner process (don't know about runtime, though):
     INSERT INTO nodupes_set_table ( all_columns )
     SELECT all_columns
     FROM    dupes_table;


refer to teradata forum for more info

The following example shows how to create table and insert 
data without duplicate rows from existing table:

CREATE TABLE NODUPS AS
(
	SELECT * FROM Departments
	UNION
	SELECT * FROM Departments
)
WITH DATA;

MultiLoad is going to need to know the structure the INPUT 
flat file. Use the .LAYOUT command to name the layout.
It is used to designate the starting location for this data 
based on the previous fields length. If you are listing 
fields in order and need to skip a few bytes in the record, 
you can either use the .FILLER (like above) to position to 
the cursor to the next field, or the "*" on the Dept_No 
field could have been replaced with the number 132 ( CHAR
(11)+CHAR(20)+CHAR(100)+1 ). Then, the .FILLER is not needed

In .IMPORT command in MLoad  we have a option to give 
record no. from which processing should begin. ie. ‘FROM m’
‘m’ is a logical record number, as an integer, of the 
record in the identified data source where processing is
to begin. You can mention ’m’ as 2 and processing will 
start from second record.

THRU k and FOR n are two options in the same MLoad command, 
functions same towards the end of the processing.

Like FastLoad, MultiLoad does not support Unique Secondary 
Indexes (USIs). But unlike FastLoad, it does support the 
use of Non-Unique Secondary Indexes (NUSIs) because the 
index subtable row is on the same AMP as the data row. 
MultiLoad uses every AMP independently and in parallel. If 
two AMPs must communicate, they are not independent. 
Therefore, a NUSI (same AMP) is fine, but a USI (different 
AMP) is not.

Hi Madhu

Thanks for ur response but could u pls explain ur answer in more detail, if possible with an example?

Thanks again.

When table is having NUSI, the sub table created by it will
be populated only by Hashing (not like Hash Re distribution
for USI), here redistribution of the records will not be
done,which will take more time generally,

As Fastload and Multiload are intended to Load the data at
fast they have taken out the USI, support so that the target
tables will be loaded very faster,

if we need we can create the SI after loading

---
If you have better ANS please Share with us

Sel HASHAMP(HASHBUCKET(HASHROW(PRIMARY_INDEX_COLUMNS))) 
 AS AMP_NO,
 COUNT(*) 
From DATABASENAME.TABLE_NAME
 GROUP BY 1;

V2R6 included the feature of replica in it.in which copy of
data base are available on another system. V2R6 provide the
additional data protection as comparison to V2R5 while if
data from one system has been vanishes.

send ur 
Test mail   to  srinu.srinuvas@gmail.com

MAIL ME,,

DINESH.TERADATA@GMAIL.COM

please follow the Minimun Basics for this free Fourm,,

Try to ACT like or Attract More TERADATA people.

ok Girish,
can u send the SYNTAX for Filler command

while using the mload of fastload if you don;t want to load
a particular filed in the datafile to the target then use
this filler command to achieve this

For Srinu, i am posting my answer insted of girish for 
SYNTAX for FILLER.

.LAYOUT FILE_IN; /* It is input file layout name */
 .FIELD Emp_No * char(11); /* to load data in to Emp_no */
 .FILLER Junk_chars * char(20); /* to skip the value for 
the next 10 locations */

TPUMP

Can any one or Srinu explain the How TPUMP actually handles the RI?