What is galaxy shema
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 |
If we have lookup table in workflow how do you trouble shhot to increase performance?
What is the Difference between SetVariable and setmaxvariable in informatica?
where does the default group roew in a router is stored what is the default size of memory in router
Describe an informatica powercenter?
Whats there in global repository
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....
What is the difference between stop and abort in informatica
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
In which transformation you cannot drag ports into it?
1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override