Answer / cc

List sequel contain detail data,crosstab sequel contain summary data

Answer / ashok

As of My Assumption you are talking about the sql's generated for Lists and Crostabs.

Here is the answer

List: List SQL gives us the detail kind of Information in the Query

Crostab: Crosstab SQL gives us the Summary Kind of information for the intersection of rows and Colums.

What is the difference between macro & Parameter

1 Answers   IBM,

---

What is a Transformer?

0 Answers  

---

write the sql query to display 5th and 10th row in a table?

5 Answers   CTS, IBM,

---

hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

0 Answers  

---

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?

0 Answers   IBM,

---

How we check the errors before running the report,plz let me know the answer

4 Answers   TCS,

---

What are the steps to import the two data sources in framework manager?

0 Answers  

---

Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin

7 Answers   IBM,

---

WHAT ARE THE TYPES OF LIST REPORTS?

4 Answers   Patni,

---

Define catalog in cognos and write its various types?

0 Answers  

---

Hi, I am Searching on Cognos 8, If any experienced person can send out a project or explain a realtime scenario that would be very helpful for me. Please be kind towards me and help me in this regard. I am really finding difficult to find a person who can guide me in this feild. Your help will be highly appriciated. My email id is balajishriram@gmail.com. Hope you will help....

3 Answers   Deloitte,

---

what is the difference between aggregation and roll up aggregation?

1 Answers  

---