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 / prabakaran
FLSDM is a 3nf model, vanilla made to cater a Bank's EDW
Star Schema is a denormalized model
|Is This Answer Correct ?||10 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 ?||18 Yes||12 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|
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
can we join volatile table with general table an global temporary table with general table ?
How many macros we can create inside a macro
How can we load single row of data into teradata database. please give me the process.
i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.
In your project what type of issues and errors you facing in Teradata
Hi send me the Teradata dumps to my id email@example.com Thanks Rajesh. A
i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?
I want to write one query How to get Matched records and unmatched records in table?
Why AMP & PE are called Vprocs?
what is the query for retrieve the unique values(not display the duplicates values) from single table?