Interested to Buy Any Domain ? << Click Here >> for more details...
Discuss the advantages & Disadvantages of star & snowflake
schema?
- 5 Answers
- 47016 Views
- I also Faced
- E-Mail Answers
Answer Posted / krishna
in starschema the fact is denormalised ...all dimension
tables are normalise..there will be primary foreignkey
relation ship between fact and dimension tables.
for better perfomance we use starschema when compare to
snow flake schema ..where fact table and dimension tables
are normalised...for every dimension table tthere will be a
look table ..we have to dig from top to bottom in the
snowflake schema.
| Is This Answer Correct ? | 18 Yes | 28 No |
Post New Answer View All Answers
What is deployment group?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Describe expression transformation?
How can you generate reports in informatica?
How many ways are there to create ports?
How to do unit testing in informatica?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Mention few advantages of router transformation over filter transformation.
What is workflow? What are the components of the workflow manager?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Explain the scenario which compels informatica server to reject files?
What is the difference between Active and Passive transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
