Answer Posted / 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 |
Post New Answer View All Answers
Difference between Target-based loading and constraint-based loading?
What are the types of caches in lookup? Explain them.
What are the different lookup cache(s)?
What is an unconnected transformation?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
How is union transformation utilized?
server hot-ws270 is connect to Repository B. What does it mean?
What is the need of an ETL tool?
Tell me about Propagate functions in informatica
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Differences between version 7.x and 8.x.
what are factless facts? And in which scenario will you use such kinds of fact tables.
How do you remove duplicate records in informatica? And how many ways are there to do it?
How do you migrate data from one environment to another?
Reusable transformation and shortcut differences