Answers were Sorted based on User's Feedback
Answer / gopal
Collection of multiple fact tables surrounded by dimension is called galaxy or multistar or fact consultaion Schema.
|Is This Answer Correct ?||5 Yes||0 No|
Answer / b.indu
A combination of star schema and snow flake star schema is known as galaxy schema
|Is This Answer Correct ?||4 Yes||0 No|
What are differences between Informatica 7.1 and 6.1
Explian the connected and unconnected lookup transformation
Whats there in global repository
How to find from a source which has 10,000 records, find the average between 500th to 600th record?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
Repository user profiles
TELL ME ABOUT WORK FLOW SCHEDULING?
what is metadata?
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?
Differences between version 7.x and 8.x.
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?