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 / 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 ?    10 Yes 3 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 12 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

what is the difference between start schma and Fsldm?

5 Answers   Intel,


Aborted in Phase 1 data Acquistion Incomplete in fastload?

2 Answers  


which option is used to restart the fastexport script ?

2 Answers   TCS,


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  


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

0 Answers  






Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

0 Answers   HP,


Where we use PPI in real time??? What is the disadvantages of PPI?

3 Answers   IBM, Mphasis,


any one answer me how they can analyzing the project using data ware housing?

0 Answers  


IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.

10 Answers  


If the table does not have duplicates then which utility you can suggest to load the data ?

3 Answers  


Can any one please provide me practical example of How to do the performance tuning in Query??

5 Answers   Amdocs,


sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?

3 Answers   CTS,






Categories