What is the difference between Sychronisatio and join?
- 2 Answers
- 6747 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / karthik
At web I level, when the Query designed by BO, these two
options (join / Synchronization).
Join happens when "Multiple SQL allowed for each Measure" is
checked in BO universe.
Synchronization Normally happens due to the selected object
is out of the selected context.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sagarika
join : join is giving a relationship between 2 tables in a
universe.
example: customer table and department table.
linking these two table is called join.
Synchronisation : retrieving data from two dataproviders
with common column and then synchronise to get the result.
| Is This Answer Correct ? | 4 Yes | 4 No |
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
please anyone explain me the derived table with the problem tables.
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
limitaions of cross tab ?
what is optional prompt in boxi r2
Without using OBJECTS Can i write AND run a query in webi/desi? HOW?
Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:<servername>/olap/msmdpump.dll" I am using ms sql server 2012 -- cube
IF I WANT TO INSTALL BO ENTERPRISE PRODUCTS IN WINDOWS 2000 PROFESSIONAL SERVER ,WHAT SHOULD BE THE SYSTEM CONFIGURATION?
Hi ,how many shortcut joins used in a single universe? Thanks in Advance
how to solve the incompatible objects and how they are formed actually.
WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?
can any one say me exactly when and where alias and context are used in resolving a loop. If possible try to give me a scenario also.
Teradata 
