Answer / raja

FM generates the separate query for each fact table. combining the all and get single output is calld.

Answer / pagu

Stich query is a query which in turns having one subquery
for each fact table and process using full outer join.

If there is combination of coalesce and full outer join
then it's a stich query

1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE

0 Answers   IBM,

---

Explain the workflow of your current project from end to end?what is the steps?

2 Answers   Accenture, Cap Gemini, Cognizant, HCL, IBM, Infosys, Nokia,

---

How many fact tables and dimension tables in your project?

3 Answers   IBM,

---

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 are the types of studio?

0 Answers  

---

how will optimiz the performance of sql in FM ?

2 Answers   Infosys,

---

If anyone need COGNOS 8 Certification Dumps of any "COG - Code", u can get from S_Cog@Yahoo.Com, i scored 100 % with these Dumps

1 Answers  

---

What is Crossproduct?

2 Answers  

---

What is Correlated sub-query? Please explain

1 Answers   Target,

---

what does my folder and public folder contains? difference between the my folder and public folder?

3 Answers   HCL,

---

Wht is difference between content store and content manager?

2 Answers   Satyam, Tech Mahindra,

---

What is the use of Tree Prompt? Where it is used?Pls give me a real time example?

1 Answers  

---