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 reusable transformation?
Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?
what is mean by grouping of condition column in lookup transformation?
Do you find any difficulty while working with flat files as source and target?
How you prepared reports for OLAP?
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?
Explain lookup transformation is active in informatica
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
What is olap (on-line analytical processing?
hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.
What the difference is between a database, a data warehouse and a data mart?