2.What is loop? How resolve the loop?explain it?
- 11 Answers
- 60465 Views
- TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / rahul tandon
Loop is a situation in the BO universe design process. A
circular path of joins is formed between the tables. The
SQL queries are not able to interpret the joins; this
results in the wrong results from the queries; often less
records are retrieved than the actual number of records.
A loop situation can be resolved by Aliases and Contexts.
Make sure to break the joins(circular path) by aliasing the
table(dimension table) which has 1n's coming out of it from
both the end. The path then gets broken and ends as two
different path, one ending at the original dimension table
and the other at the aliased table(of that dimension). Both
of the paths now convey a differnt business case scenario
and depending upon the scenario a particlar path(query has
to be fired).
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Explain how we drill up week to month?
Explain what is the difference between slice and dice and cross tab report?
What Is Snow Flake Schema?
Explain about a task that really tested your analytical abilities?
what is universe null
Explain what would you consider as your biggest achievement and why?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain difference between zabo and webi?
Explain which versions are used in the bo dashboard work?
What is thumbnail?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
U r project in which stage in implementation?
What is the difference between user and versatile user?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
