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
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
Difference between Target-based loading and constraint-based loading?
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
What is repository manager?
What is the difference between writing a joiner query in ANSI style and THETA style?
How to generate sequence numbers using expression transformation?
Explain sessions. Explain how batches are used to combine executions?
what is $$$$?
What are the tuning techniques you applied during your last project
Define the various join types of joiner transformation?
What are the settings that you use to configure the joiner transformation?
Which development components of informatica have the highest usage?
What is meant by incremental aggregation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Partition, what happens if the specified key range is shorter and longer