How can we build data marts from FSLDM. is there any
standard approach for this?Is FSLDM supports place ?
Answers were Sorted based on User's Feedback
Answer / saurabh
In teradata, we can create another database which will
contain all the views for a given subject area. These views
togeather will form a logical datamart for that set of
business users.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sagar
Teradata is like all other DBMS, we can create as many
database as required. Data Mart are basically subject
oriented and mainly based on business KPIs which end-users
generally like to measure. You have to refer business
requirement document for designing data mart.
| Is This Answer Correct ? | 3 Yes | 1 No |
what is a multi statement request in TD? what is the diif b/w V2R5 & TD12? what is the diff b/w MACRO & STORED PROCEDURE?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
How to find duplicates in a table?
what is object level locking ? where do appear this type of locking ?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What is called partitioned primary index (ppi)?
What is meant by a dispatcher?
Describe primary index in teradata?
How to eliminate product joins in a teradata sql query?
Explain the meaning of Amp?
What is primary index and secondary index?