What is Drill up/down/by/through
Explain what is meant by the Drill up/down/by/through?
Expert
a) Drill mode enables you to analyze the data from several angles and on the different levels of detail.
b) Drill down exhibits the next level of detail in the hierarchy.
c) Drill up goes back up through the hierarchy in order to display the data over the less detailed levels.
d) By using the Drill through the option you may move to the other hierarchy in order to analyze other data which belongs to the different hierarchy.
e) Drill Through - If lowest level of detail you require is not currently available within the report, you may drill through to the database directly from the drill mode and obtain the data you require. You do not need to edit the query within the Query Panel.
Briefly describe the foreign key columns in dimension table and fact table?
Differentiates Tuple-oriented relational calculus and domain-oriented relational calculus?
Describe in brief about the Sybase group?
What is meant by the Cardinality?What is meant by the Cardinality?
Explain the command line functions which export and import the DS jobs?
When two relational tables is connected to SQ Trans, what are the probable errors it will be thrown?
Define the term Smoothing.
Explain the working of the IPC Stage?
Briefly describe snow flake system design in database?
What the difference between sequential file stage and hashed file stage is in relates to DataStage Server?
18,76,764
1936832 Asked
3,689
Active Tutors
1455664
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!