My data source is Excel sheet. How to write the SQL
Statement for Excel file in data provider? Is is possible?
Answer Posted / obaidullah shareef
If we want to transfer the data from excel to Data base
table, you need to write one pl/sql code for that, this can
be easily done in Oracle Application with the help of
selecting the right table. This process is called inbound
interface in oracle apps and the file is called flat file.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the profile and package?
Explain when to use local filter and when to use global filter?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Can Bo generates the Report from the cubical data Explain?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Explain the difference between detect alias and detect context?
Explain how we drill up week to month?
What is aggregate table and aggregate fact table ... Any examples of both?
Can we Save (save as) WEBI Doc as DESKI?
In banking domain how many Fact tables,Dimension table are present?
Give some information on report bursting?
What sort of existing documents should business analysts refer to when starting on a new project?
Difference between zabo and webi?