What is Relational Integrity?
Answer / singh
The relationship maintained by the Foreign key with its Base Table is referred to as relational integrity.
Is This Answer Correct ? | 3 Yes | 0 No |
Explain different types of partitioning?
what is SMP AND MPP?
how would u estimate the size of Lookup transform data and index cache?
Is apache nifi an etl tool?
what are the facilities provided by OLAP to analytical users?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
Explain what are the various etl tools in the market?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
Difference between flat files and relational sources?
what is the difference between cardinality and Nullability?
how do u implement configuration management in Informatica?
how do u implement unconn.stored proc. in a mapping?