ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Teradata
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
what is the difference between start schma and Fsldm?  
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is the difference between start schma and Fsldm?
Answer
# 1
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 ?    2 Yes 0 No
Shubhangi
 
  Re: what is the difference between start schma and Fsldm?
Answer
# 2
FSLDM -> 3rd normal form
Star Schema --> Denormalized for query performance
 
Is This Answer Correct ?    2 Yes 0 No
Saurabh
 
 
 
  Re: what is the difference between start schma and Fsldm?
Answer
# 3
FLSDM is a 3nf model, vanilla made to cater a Bank's EDW 
need.

Star Schema is a denormalized model
 
Is This Answer Correct ?    0 Yes 0 No
Prabakaran
 

 
 
 
Other Teradata Interview Questions
 
  Question Asked @ Answers
 
can we have an unconnected lkp to lookup a DB2 record against a Teradata record? IBM1
What is a common data source for the central enterprise data warehouse?  1
Why Fload doesn’t support multiset table?  1
Can we load a Multi set table using MLOAD?  1
What is the process to restart the multiload if it fails?  2
Explain about Skew Factor?  2
IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.  1
Why AMP & PE are called Vprocs?  1
How does indexing improve query performance? Satyam2
What is the diffrence between Multiload & Fastload interms of Performance? Intel3
What are the types of tables in Teradata Infosys5
can I use “drop” statement in the utility “fload”? Accenture1
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.  1
How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?  2
What is use of compress in terdata?Explain?  1
Does SDLC changes when you use Teradata instead of Oracle?  1
what is the difference between start schma and Fsldm? Intel3
In which phase of the Active Data Warehouse evolution do you use data to determine what will happen? IBM2
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.  4
What are two examples of an OLTP environment?  1
 
For more Teradata Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com