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
While migrating the data from one environment to another environment how would you manage the connections?
What is data caches/ index caches?
how to load dimension table and fact table. plz tell me the steps.
Design a mapping to load the cumulative sum of salaries of employees into target table?
Make a note of the quantity vaults made in informatica?
What is the difference between informatics 7x and 8x and what is latest version?
What is informatica metadata and where is it stored?
Write the advantages of partitioning a session?
What are the types of caches in lookup? Explain them.
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is the need of an ETL tool?
Enterprise data warehouse your projects phase by phase explain?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are the different types of repositories created using informatica?