What is degenerated dimention table?

Answer Posted / seetharam

The dimension keys which are directly cming from the oltp
system with out any associated dimension to the fact table
.These are called degenerate dim or line item dimensions

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1690


Difference between Target-based loading and constraint-based loading?

556


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1539


What is repository manager?

538


What is the difference between writing a joiner query in ANSI style and THETA style?

1925






How to generate sequence numbers using expression transformation?

646


Explain sessions. Explain how batches are used to combine executions?

601


what is $$$$?

1742


What are the tuning techniques you applied during your last project

1567


Define the various join types of joiner transformation?

561


What are the settings that you use to configure the joiner transformation?

617


Which development components of informatica have the highest usage?

596


What is meant by incremental aggregation?

589


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

638


Partition, what happens if the specified key range is shorter and longer

2031