How can we find out cardinality between two tables?
Answer Posted / sharath.dwh
IN FRAMEWORKMANAGER GO TO WE HAVE 3 TABS
1)EXPLORER TAB
2)DIAGRAM MAP TAB
3)DIMENSION TAB
WE CAN CHECK CARDINALITY BETWEEN TWO TABLES IN DIAGRAM TAB.
SHARATH
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is meant by Reportstudio shortcut?
Can you define drill down and drill up?
how u will determine the performence tune will occur either in report or system
What is defined as data mining?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
how u will design the report if the objects are available
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
What do you understand by the term 'dynamic cube'?
What are the components of the report studio?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
What is a dimension?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
How to apply securities for reports in cognos connection?
What is model filter?
Explain what is the difference between microstrategy and cognos reporting tool?