What are the different types of schemas?
- 11 Answers
- 83098 Views
- ITC Infotech, I also Faced
- E-Mail Answers
Answer Posted / chowdary
There are two types of shemas
1 star schema , 2 snowflake schema
star schema : a fact table related to tha dimension tables
like in the fact table it contain refernce keys of
dimension tables. and dimension tables dont related to the
other parent table . it view like a star so its call star
schema. if this use to avoid more joins
snowflake schema: a dimenion table with related to the it
hirerchi tables. like time dimensin table year dimension
table, month month dimension table, week dimension table
it view like snowflake
| Is This Answer Correct ? | 23 Yes | 26 No |
Post New Answer View All Answers
What is a pre-defined event and user-defined event?
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. ?
Explain your project of banking domian.
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the fact table?
What is olap (on-line analytical processing?
What is informatica worklet?
What are the features of complex mapping?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
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
Differentiate between reusable transformation and mapplet.
Explain the pipeline partition with real time example?
How to load data in informatica ?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
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?
