set of level properties that describe a specific aspect of a business, used for analyzing the factual measures of one or more cubes, which use that dimension. Egs. Geography, time, customer and product.
Latest Answer: Dimensions that change over time are called Slowly Changing Dimensions.Slowly Changing Dimensions are often categorized into three types namely Type1, Type2 and Type3. Type 1 -> Overwriting the old data.Type 2 -> Creating an another additional ...
Latest Answer: DMLs can be used against view (if they are based on 1 table with no aggr funs) ...
In Dimensional modeling fact table is normalized or denormalized?in case of star schema and incase of snow flake schema?
Latest Answer: Hai, Gopinath. What u told is correct. But in the case of SCD Type2 we will have not only current ...
Router transformation allows you to use a condition to test data. It is similar to filter transformation. It allows the testing to be done on one or more conditions.
Latest Answer: Router Transformation is same as that of Filter Transformation.The only difference is that we can specify only one condion for filter but for Router we can specify many condition and one more thing the data which are not satisfying the filter conditions ...
1.how to enter same record twice in target table? give me syntax.2. how to get particular record from the table in informatica?3.how to create primary key only on odd numbers?4. how to get the records starting with particular letter like A in informatica?
Latest Answer: You can modify the flat file using shell scripting in unix ( awk, grep, sed ).Hope this helps. ...
Latest Answer: hiplease see the following site: http://72.14.253.104/search?q=cache:lkFjt6EmsxMJ:www.kimballgroup.com/html/commentarysub2.html+fact+table+normalized+or+denormalized&hl=en&gl=us&ct=clnk&cd=1I am highlighting what Kimball says here: " Dimensional ...
Latest Answer: I think if the transformation is created in Mapping designer and make it as reusable then we can revert back that one by the option "revert Back". But if we create transformation in Mapplet we can make it as non reusable one ...
Both pipelines begin with the same original data source. Both input pipelines originate from the same Source Qualifier transformation. Both input pipelines originate from the same Normalizer transformation.
Latest Answer: We cannot use joiner transformation in the following two conditions:-1. When our data comes through Update Strategy transformation, or in other words after Update strategy we cannot add joiner transformation2. We cannot connect a Sequence Generator transformation ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>

Go Top