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 |
What is the difference between bitmap and btree index?
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
How will u pas the data with out debugger?
Explain what are the different versions of informatica?
Where are the source flat files kept before running the session?
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
what are the deliverables?in your project?
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
What is a rank transform?