Interested to Buy Any Domain ? << Click Here >> for more details...
What is confirmed dimension?
- 3 Answers
- 9983 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / seshagiri k
A dimension which can be shared with multiple fact tables
OR
A dimension which can be used by one or more fact tables is
called confirmed dimension
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / murali
in the schema, if any any dimension table has been shared
by more than one fact table, it is called as "confirmed
dimension"
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / sree
In addition to that , it is consistent across the data
marts.
| Is This Answer Correct ? | 4 Yes | 1 No |
How to create or import flat file definition in to the warehouse designer?
Explain the etl program with few examples.
The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?
Can we run session without using workflows?
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
what is the use of Java Transformation in Informatica 8.x?
What is difference between a gateway node and worker node?
How would you copy the content of one repository to another repository?
What are the components of workflow manager?
Is there any model difference between ODS and DWH
How union transformation is active ?
how to get flatfile containg 10 records half records one target another half another target
Teradata 
