Answered Questions

  • how many types of dimensions are available in informatica?

    Santosh

    • Dec 26th, 2011

    In Informatica 4 types of dimensions are available, these are 1) Degenerate dimensions 2) Junk dimesnsions ( a dimension which contains the less numbers of cordinality vales are less number of ind...

    suren

    • Nov 22nd, 2011

    Hi Guys, Please don't answer wrong answers the above mentioned are Schema. , the dimension are discussed bellow. 1.Junk Dimension:Contains miscellaneous data such as flags and indicator 2.Degener...

  • what is fact less fact table? where you have used it in your project?

    cognos_anu

    • Jun 20th, 2017

    Fact less fact table contains only foreign keys/ids.
    They don't contain measures/fact, numeric data.
    They are used to capture the events.
    for e.g. to capture attendance records

    Sandipana

    • Jan 20th, 2015

    A factless fact table is fact table that does not contain fact. They contain only dimensional keys and it captures events that happen only at information level but not included in the calculations lev...

  • What is Fact table

    Answer posted by Chintan on 2005-05-22 18:46:03: A table in a data warehouse whose entries describe data in a fact table. Dimension tables contain the data from which dimensions are created.