Answer / bob

1.Can we use 2 packages in report studio at a time is there
any alternative for this?

No, we can not use two packages to in RS. The reason is
that a package itself has data sourced from different data
sources. Hence, there is no alternative to do this. Infact,
you can have links b\w two packages in FM.

2. What are Star Dimensions and Star Facts?

There is nothing called as Star diamension and Start Fact.
Yes, we do have star schema; technically speaking an
arrangement of object that are in your model i.e. table,
views, indexes in to a start structure. Here, the fact
table is central to the schema and surrounded by your
diamension tables originating from the center of the fact
table giving it a start design.

3.What are dimensions and facts in project ?

Diamnesion are tables that consists of attributes which are
descriptive in nature. We also call it a look uo when we
are in the fact table. Whereas, the fact table consists of
foreign keys (compounded) and aggregate or summary values.
The fact table hence has fact regarding the business e.g.
qty, revenue, gross profit, etc.

4.What is difference between 3 NF and Star Schema ?

3NF or third normal form is a rule for normalization of
tables. You have to learn 1NF and 2NF to know what actually
3NF is. Anyhow, they are used in OLTP systems where the
transcation is current and shoes upto date information.
Whereas, start schema is usually used in DW and hence, has
highly denoprmalized structure. This reduces the number of
joins that we may have when going for normalization and
makes DW fact for query retrieval.

6. How much time do u need to create a report ,if u have
four dimensions and 1 fact ?

Which is the report you are going to build? This should be
your question to the interviewer. If, you have the skilss
then a report author should not takke more then 20 minutes
to prepare a complex report with some filters and prompts.

7. How do u create a Model ?

If the question is abt how you are going to create a model
in FM then this are the steps;

a) Prepare the data sources.
b) Analyze and gather requirements.
c) Plan: which includes high level documentataion and Low
level documentation.
d) Implement: Design and development process.
e)Test: USe some test criteria.
f)Deploy: Moving from development to production.
g) Evolve: Adapt new features once deployed.

8. How do u connect a Parameter in a list ,such a way it
has to show relative objects in Cross tab ?

You may use the Master Detail relationship functionality in
RS to acheive this task. Remember, this will klead the
intrerview to ask on hoe u create MD relationship.

Can you define dimension?

0 Answers  

---

Mail me at: Amit_Cog@yahoo.com for a Very latest COGNOS 8 Certi Dumps like COG-112, COG-122, COG-125, COG-132, COG-142, COG-145 I scored Full Score, if anyone need it, just drop me a mail with Code

8 Answers  

---

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  

---

Q1. We have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'. Q2. If my Cube size is 2GB, now I have got the requirement to reduce it. What are the parameters I have to follow to reduce the cube size? Q3. How to get the 2nd highest salary of an employee without using any function (I mean without rownum etc.)? Q4. What is the difference between joins and scope relationship?

5 Answers   Mphasis,

---

what is the difference between list report and crosstab report?

0 Answers   IBM,

---

Can you define fan trap?

0 Answers  

---

What is set to be cardinality?

0 Answers  

---

how many types of keys are there i.e primary key and foreign key etc..?

3 Answers   IBM,

---

What is Clipboard? How to import XML file into Clipboard?

2 Answers   CSC, HCL,

---

How can you schedule a report based on different time zone ?(ex: local time should be same as 10 am . Japan should get the report at 10 am. USA should get the report at 10 am).Is that possible?

1 Answers   HCL, iGate,

---

using of matric studio we can developed to scorecard ... what is the meaning by scorecords

1 Answers  

---

Why we should go for cognos? when there are so many other BI(Reporting) tolls in front of us?

4 Answers   IBM, Wipro,

---