What is degenerated dimention table?

Answer Posted / sujana

it is generated at runtime..acts as pk in fact table..

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between Data and Index Caches?

668


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

1543


What is a pre-defined event and user-defined event?

587


What is the use of an aggregator cache file?

699


What does refresh system mean, and what are its distinctive choice?

580






What is aggregator transformation in informatica?

553


How do you manage the Parameter files while migrating your data from one environment to another environment?

566


What is target designer and target load order?

669


How can one identify whether mapping is correct or not without connecting session?

899


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1788


What is an aggregator transformation?

624


What is data movement mode in Informatica and difference between them?

632


Which transformation should we use to normalise the COBOL and relational sources?

753


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1342


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1459