WHAT DOES SQL TAB CONTAIN?
Answer / 19-10-2011
IT CONTAINS CARTISIAN TAB,SET OPERATION LIKE UNION,MINUS.
| Is This Answer Correct ? | 7 Yes | 1 No |
1.what is context? How u create? With example.
What are the Errors in BO Pls Explain with Examples
2 Answers iFlex, Tech Mahindra,
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
what are the debuggings in the business objects?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
please differentiate star schema and snow fleak schema with dimension table, how end user is depending on them in creating reports.
I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)
what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance
what is Scope of Analysis
am a fresher hw to get real time experience?
explain in detail about type 3?
HOW MANY TABLES ARE EXISTED IN WEBI REPORT?