Interested to Buy Any Domain ? << Click Here >> for more details...
what is confirmed dimension?
- 6 Answers
- 13467 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sri ram
Conformed dimension is a dimension which is connected to or
shared by more than one fact table.
Eg:A business which takes care of both sales and orders of
products then product dimension becomes a conformed
dimension for both sales fact and order fact
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / rr
A dimension that will remains unchanged in entire
datawarehouse. It can be used across all the fact tables.
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / suresh godugu
A dimension that carries the same meaning across the
different fact tables in called conformed dimension
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / mohini
the dimention table is connect to fact table.the splitted dimention tables are also connect the fact tables.the spiltted dimention tables also carries the same meaning across the total transaction.the dimention tables contains denormalized data.ths z called confirmed dimension.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / jayachandra
A dimenssion which is shared by multiple fact tables is
known as "Confirmed dimenssion".
ex:customer dimenssion
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / lokii
A dimension which connects a fact table and a factless fact
table.
| Is This Answer Correct ? | 1 Yes | 7 No |
How can we delete duplicate rows from flat files?
Different circumstance which drives informatica server to expel records?
how can we perform incremental aggregation?explain with example?
scenario where i can use only concurrent execution of workflow.
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What are data-driven sessions?
What is meant by pre and post session shell command?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
How to differentiate between the active and passive transformations?
I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?
How can we remove the duplicates from flat file source?
Teradata 
