Answer / sathish

its a branch of fact-table,
fact-table act as a center of a star, other table act as a
direction to fact


dimension
|
dimension - FACT - dimension
|
dimension

Answer / divakar

Dimension is an object which contain descriptive data i.e.
Customer name, Address etc., these will give infor about
the customer.There are many kinds of dimensions in real
time like Degenerate dimensions, conformed dimensions, junk
dimensions etc..

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

0 Answers  

---

What are differences between Reporter report and Explorer report?

2 Answers  

---

How u provide security to reports in report studio or in cognos connection?

1 Answers   Cap Gemini,

---

What is difference between informatica power mart and power center?

0 Answers  

---

Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??

2 Answers   Barclays,

---

What DB View and Bus View?

0 Answers  

---

For example I developed some reports on employee package now I have to develop same reports to another package.How can I change reports to another package?

5 Answers   TCS,

---

What is Index?

2 Answers  

---

What are the components required for the application tier?

1 Answers  

---

Part 1 : Cognos 1.What are the technologies that are used in cognos? 2.What are complex reports? 3.What is page break? 4.What is layout component? 5.How do you use extract function? 6.What is the use of Crosstab space? 7.What is Rank()? 8.What is the use of Query calculation and layout calculation? 9.What is Slicer and Dicer? 10.How can you create users in Cognos? 11.What is last child member? 12.What is the use of Conditional blocks? 13.What is Conditional Formatting? 14.What is group span? 15.In which types of reports does the page breaks applicable? Is it applicable in excel reports? 16.I want to show a up arrow and down arrow image in cross tab report, if the revenue is > 5000 (up arrow) and if <5000 (down arrow)? How will you achieve this? 17.What are types of Filters in RS? What is Summary Filter and Detail Filter? 18.What is Cast Function? 19.How will you create prompts for the example like this : In a single report I want a) List report (Need a prompt for this) b) Crosstab report (Need a separate prompt for this) c) Chart ()(Need a separate prompt for this) Part II : Framework Manager (FM) 1. What is Determinant in FM? 2. What is Cardinality? 3. What are the types of filters used in FM? 4. Can we create cubes with Relational Data sources? 5. What is Aliasing and Shortcut? 6. What is Session Parameter & Parameter Maps? 7. How many types of securities that we have in FM? 8. What is Data Security in FM? Part III : Data warehousing 1.What are various types of Schemas? 2.What is Star Schema and Snow Flow Schema? Difference between both? 3.What is surrogate key? Part IV : Databases 1.What are NVL Functions? 2.What is left outer join? Give an Example? 3.Can we straightaway use the tables that we have in the database instead of creating the package’s FM and making use of them, through Report Studio (RS)?

2 Answers   Satyam,

---

Which one is better among Value and select & search prompts,in terms of performance?

2 Answers   L&T,

---

How do you test the reports? Explain the Unit testing procedures after developing the reports?

1 Answers   HP, TCS,

---