Teradata Data type abbreviation - described

Teradata data types (as reported in DBC.Columns.ColumnType can be cryptic and not always easy to remember.  Here's a ready reckoner - 

Abbreviation	Equivalent English :)
A1	ARRAY
AN	MULTI-DIMENSIONAL ARRAY
AT	TIME
BF	BYTE
BO	BLOB
BV	VARBYTE
CF	CHARACTER
CO	CLOB
CV	VARCHAR
D	DECIMAL
DA	DATE
DH	INTERVAL DAY TO HOUR
DM	INTERVAL DAY TO MINUTE
DS	INTERVAL DAY TO SECOND
DY	INTERVAL DAY
F	FLOAT
HM	INTERVAL HOUR TO MINUTE
HS	INTERVAL HOUR TO SECOND
HR	INTERVAL HOUR
I	INTEGER
I1	BYTEINT
I2	SMALLINT
I8	BIGINT
JN	JSON
MI	INTERVAL MINUTE
MO	INTERVAL MONTH
MS	INTERVAL MINUTE TO SECOND
N	NUMBER
PD	PERIOD(DATE)
PM	PERIOD(TIMESTAMP WITH TIME ZONE)
PS	PERIOD(TIMESTAMP)
PT	PERIOD(TIME)
PZ	PERIOD(TIME WITH TIME ZONE)
SC	INTERVAL SECOND
SZ	TIMESTAMP WITH TIME ZONE
TS	TIMESTAMP
TZ	TIME WITH TIME ZONE
UT	UDT Type
XM	XML
YM	INTERVAL YEAR TO MONTH
YR	INTERVAL YEAR
=++	TD_ANYTYPE

Trying to become a Data warehousing architect... !!!

If someone wants to become a DW Architect, there is a lot of knowledge required.  Some of the different perspectives (one from MS not specifically for DW, rather enterprise) and another on DW specifically..

Although I think its strange already that someone has to think about the kind of questions being asked in such interview, there are things posted on these lines.  i believe its more of a discussion on thought process and approach rather than question-answer session in such an interview. Still, presenting an excerpt, outlining some of the interesting topics that might turn up in a discussion for this kind of position.

1. Describe advantages of the CIF architecture versus the bus architecture with conformed dimensions. Which would fit best in our environment given [some parameters they give you] and why
2. Describe snow-flaking
3. Describe fact-less fact tables.
4. Draw a star schema of our business
5. Describe common optimization techniques applied at the data model level
6. How do you handle data rejects in a warehouse architecture?
7. Describe common techniques for loading from the staging area to the warehouse when you only have a small window.
8. How do you load type 1 dimensions
9. How do you load type 2 dimensions, and how would you load it given our [insert business particularity]
10. How would you model unbalanced hierarchies
11. How would you model cyclic relations
12. What major elements would you include in an audit model?
13. How would you implement trace-ability ?

Questions picked up from http://arstechnica.com/civis/viewtopic.php?f=20&t=320772

One of the Microsoft guys wrote about possible feathers in the cap of an Enterprise Architect -  http://blogs.msdn.com/b/nickmalik/archive/2006/09/09/ea-interviews.aspx