why less number of records in loop?
why more number of records in traps?
- 1 Answers
- 3037 Views
- Wipro, I also Faced
- E-Mail Answers
Answer / manveer
More no of records in trap because:
For example:
A >- B -< C
( Employees >-- Showroom --< Salary)
- Each showroom has many employees
- Each showroom has many annual salary figures
The number of employee records should not impact the total salary on the report.
If a query is written that spanned all three of those tables the data from table A and C, there would be duplicated and the measure values would be exaggerated. For example,
- X rows on the left
- Y rows on the right
- X * Y rows in the combined set
Less no of records in loop as there is an extra join in a loop, that means one more restriction to the data. That extra join filter out the data and restrict the no of rows retrieved
| Is This Answer Correct ? | 0 Yes | 0 No |
limitaions of cross tab ?
IN BOXIR2 creating universe by using Designer and Business View. What is the difference b/t two?
Can we use two different sources in webirich client to create A report ? Like universe and excel etc...
What is the difference between Thin client & thick client?
date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 remove from report how can we do this in bo xi r2
Is it possible to develop reports without Universe access?
What is a Set?
How maually can i define ? If thousends of records exists in a table?
What is Designer?
What are universe parameters?
Explain what task is 98% of the required work of a business analyst?
Can any body will explain about sarrogat key? Thanks in advance...........Prakash
Teradata 
