Define degenerate dimension table
Give a brief note on the term degenerate dimension table?
Expert
The dimensions which are persevered in the fact table are named as dimension table. Such dimensions don’t hold its individual dimensions. Mapping doesn’t take place for the columns accessible in fact tables. The values in the table are neither dimension nor evaluates.
Explain the various types of stages?
Explain Batches and Session?
Name the main data structures used in these areas: Hierarchical data model, RDBMS and Network data model?
How can we do unit testing into the informatica? How to load data in the informatica?
Explain the following terms: Proactive, Retroactive and immediate Update.
Provide a brief introduction on the term Star Schema?
Explain the term Vdisk and how this will communicate along with physical data storage at the time of data retrieval by AMP?
Give a brief introduction of the term universe in SQL? Brief explain the kinds of universes in business objects?
Describe some of the chrematistics of good data definitions.
What do you understand by the term SQL view in DBMS? Briefly describe the utilization of views?
18,76,764
1955022 Asked
3,689
Active Tutors
1439079
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!