What is confirmed dimension and fact?
Answers were Sorted based on User's Feedback
Answer / prasad.nallapati
A dimension which links with more than one fact table is
called as Confirmed dimesion.
Is This Answer Correct ? | 13 Yes | 3 No |
Answer / praveen kumar pendekanti
If a dimension exists in more than one fact table is known
as confirmed dimension. For every fact table confirmed
dimension should be there ex:: Time dimension....
Is This Answer Correct ? | 8 Yes | 4 No |
Answer / yes
It's actually a "conformed" dimension...meaning a dimension that has the same "form" over multiple data marts....
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / bebo
a confirmed dimension is a dimension which is used in more
then one datamart...exp time dim or customer dim
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / suresh
Conformed dimensions are either identical or strict mathematical subsets of the most granular, detailed dimension. Dimension tables are not conformed if the attributes are labeled differently or contain different values. Conformed dimensions come in several different flavors. At the most basic level, conformed dimensions mean exactly the same thing with every possible fact table to which they are joined. The date dimension table connected to the sales facts is identical to the date dimension connected to the inventory facts
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rukmini
The dimensions are created once but reuse in multiple times
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / rekha
A DIMENSION WHICH IS FIXED AND REUSABLE IS CALLED CONFIRMED
DIMENSION
EX : TIME
Is This Answer Correct ? | 7 Yes | 10 No |
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
what is left outer join?
What are Target Options on the Servers?
what is the difference between lookupoveride and joiner?
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
what is Partitioning ? where we can use Partition?
Can you start a session inside a batch individually?
Name at least 5 different types of transformations used in mapping design and state the use of each.?