what is the difference between start schma and Fsldm?




Answers were Sorted based on User's Feedback



Answer / saurabh

FSLDM -> 3rd normal form
Star Schema --> Denormalized for query performance

Is This Answer Correct ?    12 Yes 2 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 ?    18 Yes 10 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 ?    9 Yes 3 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

Post New Answer



More Teradata Interview Questions

What is the difference between SI and JI?

2 Answers  


what is use of fload loading into set table?

2 Answers   IBM,


how teradata fetches a row from primary index table?

1 Answers  


what is identity columns in TD?

2 Answers   Wipro,


In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?

2 Answers   Wipro, IBM,






can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

1 Answers   IBM,


We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.

2 Answers   IBM,


What is Difference b/w PI & PPI?how to implement PPI?

3 Answers   Wipro,


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

0 Answers  


Which Teradata concept allows more than one model generation?

1 Answers   TCS,


I WANT TO LEARN TERA-DATA ,SO CAN ANY BODY PLZ REFER WHAT ARE THE TOPICS I HAVE TO GO THROUGH, TO GET ASAP JOB ,SO PLZ REFER ME WHERE I CAN GET NICE COACHING ON TERADATA.

13 Answers  


Why AMP & PE are called Vprocs?

4 Answers  






Categories