Answer Posted / rajeshkumar
A conformed dimension can exist as a single dimension table that relates to multiple fact tables within the same data warehouse, or as identical dimension tables in separate data marts. Date is a common conformed dimension because its attributes (day, week, month, quarter, year, etc.) have the same meaning when joined to any fact table.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain constraint based loading in informatica
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Explain transaction control transformation in informatica
Design a mapping to load a target table with the following values from the above source?
Whats the difference between informatica powercenter server, repositoryserver and repository?
can anyone explain me about retail domain project in informatica?
What is meant by query override?
differences between service based and product based?
Write the program through which the records can be updated?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Can we create multiple integration service on single repository?
What is pmcmd command?
How you know when to use a static cache and dynamic cache in lookup transformation?
Write the prerequisite tasks to achieve the session partition?