What are the different types of schemas?
Answer Posted / ande
two types of schemas r there: Star schema and snow flake
Schema: in Snow flake schema normalozation is promoted
where as in star schema denormalization is promoted. incase
of snowflake schema DB size will be saved but no of joins
will be increased and poor performance compare with star
schema
regards,
ande
| Is This Answer Correct ? | 71 Yes | 31 No |
Post New Answer View All Answers
What all are steps in up gradation of Informatica server?
How are indexes created after completing the load process?
Explain the features of connected and unconnected lookup.
Which means the first record should come as last record and last record should come as first record and load into the target file?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Explain the shared cache and re-cache?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Describe an informatica powercenter?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Explain transaction control transformation in informatica
What is the use of code page?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Briefly describe lookup transformation?
What are the types of data warehouses?
How do you load first and last records into target table?