What are the different types of schemas?
Answer Posted / kick
Very nice page I must say.
Mainly Data warehouse has three type of schemas available.
1. Star Schema
2. Snow Flake Schema
3. Fact Constellation Schema or Galaxy Schema
It was really hard time for me to get to know exactly how this all schema works and what is the main differences between these schema.
I searched a lot on web and got one detailed answer in below link. May be this can also help you guys to understand.
http://www.aajsearch.com/142/what-are-the-different-schema-in-data-warehousing
Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
How can we use mapping variables in informatica?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What is the benefit of partitioning a session?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is confirmed fact in dataware housing?
How can we use batches?
What are the tasks that source qualifier perform?
What are connected or unconnected transformations?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Where are the source flat files kept before running the session?
design of staging area?
What are junk dimensions?
What do you mean by channel change?
What is a joiner transformation?
what is the complex transformation you used in informatica