Prospects, This is the Only place Where YOu can Find All Interview questions,Faqs and Real Stuff and scenario & Scripts with Resumes, Stick to It for Updates,,,,

Sunday, April 6, 2008

Interview Questions

What is the difference between group and association?

In cognos 'group' is used to suppress the duplicate values. And 'associate' is used to suppress the values if it is one-one relationship.

Group - It Eliminates the Duplicate values from the report break the columns. Its having a one to many relationship.

Association-It Eliminates the Duplicate values from the report and its having one-one relationship.

Both Group & Association eliminate duplicates in a column.But we cannot use Association alone.It should have one to one relationship with grouped column.

Using Association is a performance enhancement technique.

A GROUP IS USED TO ELIMINATE THE DUPLICATES IN DATA.WHERE A ASSOCIATION IS USED TO HIRE OR SUPPRESS THE VALUES IN 1 TO 1 RELATION.

What is Cardinality?

Cardinality is nothing but relation between tables like

One to One,

One to Many and

Many to Many.

Cardinality is the nature of the relationship. 1-1,1-many relation shipsCardinality is the nature of the relation between two query items

How to test reports in cognos?


Go to power play transformer, on toolbar select RUN menu. In RUN menu there is one option that is TEST BUILD you can test ur report there.

You may also test the outcome of a report by writing and executing SQL Queries and comparing the outcome with the report outcome.

BY USING SYSTEM TESTING, UNIT TESTING, PERFORMANCE TESTING

How u create security to reports?

Basically there are two types of securities for any object Levels of Securities:

1. Database level Security

2. Row level security

Even we can provide LDAP security too.

By setting up the Governors in frame work manager also we can give the security to the data accessing through the report.

1 comments:

hetra said...

Hi

I read this post two times.

I like it so much, please try to keep posting.

Let me introduce other material that may be good for our community.

Source: Security interview questions

Best regards
Henry