Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between start schma and Fsldm?
- 5 Answers
- 49786 Views
- Intel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / saurabh
FSLDM -> 3rd normal form
Star Schema --> Denormalized for query performance
| Is This Answer Correct ? | 13 Yes | 2 No |
Answer / prabakaran
FLSDM is a 3nf model, vanilla made to cater a Bank's EDW
need.
Star Schema is a denormalized model
| Is This Answer Correct ? | 11 Yes | 3 No |
Answer / shubhangi
A star schema has one Fact tables and many dimensional
tables to store the related.
FSLDM (Financial services logical data model) is a model
proposed and designed by NCR to cater the needs of financial
sectors, specially the Banking domain.
It has many Fact tabls and dimension tbls.
The major fact tbls include Party (Customers of the bank),
Product (Services offered by the bank), Event (An event
occurred ex: An ATM transaction), Agreement (A deal betweem
the party and the bank for a product)etc...
The FSLDM can be customized to cater to bank's specific needs.
| Is This Answer Correct ? | 19 Yes | 13 No |
Answer / vinay sir(datawarehousing tech
Adding more to the above:
FSLDM->It was designed with variuos Subject Areas
(PARTY,LOCATION,ADDRESS,EVENT etc...).Each Subject Area is
again made up of different Entities and all these entities
are fully normalized.
Simply FSLDM consists of Many Entities and the structure
is in 3NF.
Star Schema: This can also be called as Star Join Schema.
Star schema consists of Less Entities(Fewer Fact and
Dimension tables--preferrably one fact with many dimensions)
and the structure is Denormalized.
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / fsldmlearner
Can anyone please let me know what is the recommended ETL
design for loading FSLDM ? I saw one of the designs for ETL
for this at www.fsldm.com but want to understand if there
are any contents I can find anywhere on the various
components shown as www.fsldm.com ?
| Is This Answer Correct ? | 3 Yes | 7 No |
"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me
How can bottlenecks be identified?
what happen if a query fail in dispatcher?
in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?
What is Join Index in TD and How it works?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
What is partitioned primary index (ppi)?
How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
What is a sparse index?
Explain Teradata performance tuning and optimization?
What is logical data model?
can i call router is a passive transformation
Teradata 
