what is the difference between start schma and Fsldm?

Answers were Sorted based on User's Feedback

what is the difference between start schma and Fsldm? ..

Answer / saurabh

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

Is This Answer Correct ?    12 Yes 2 No

what is the difference between start schma and Fsldm? ..

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 11 No

what is the difference between start schma and Fsldm? ..

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 ?    9 Yes 3 No

what is the difference between start schma and Fsldm? ..

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

what is the difference between start schma and Fsldm? ..

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

Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M

6 Answers   JPMorgan Chase,

how many modules are there in telecome domain?how to explain the architecture?

0 Answers  

How do you Generate sequence at the time of Display?

2 Answers   Infosys,

How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?

2 Answers  

what is referential constraints?how do you implement RI in teradata?

2 Answers   Wipro,

I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.

4 Answers   Cap Gemini,

one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?

3 Answers   IBM,

what is object level locking ? where do appear this type of locking ?

0 Answers  

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.

1 Answers  

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

11 Answers   CTS,

Increasing no of amps will increase performance. Is this true?

5 Answers   Infosys,

what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)

4 Answers