Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


My data source is Excel sheet. How to write the SQL
Statement for Excel file in data provider? Is is possible?

Answers were Sorted based on User's Feedback



My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is i..

Answer / guest

use personel data provider and use this excel to get the
data. Automatically it will create the SQL from excel.

Is This Answer Correct ?    4 Yes 0 No

My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is i..

Answer / 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

My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is i..

Answer / stalin

If you use the personal data provider ,it will generate the
report but it will not provide any SQL.

Otherwise ust the ETL(informatica or PL/SQL ) code and
store the data in any of the data base and then generate
the data througth universe or freehand sql.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Business Objects Interview Questions

How to open a universe with out using the Designer ??

2 Answers   IBM,


What are Alerter, Filters, Breaks and Conditions?

2 Answers  


What is the purpose of @aggregate aware function?please draw, how you use the @aggregate aware function

6 Answers   Cap Gemini, Deloitte,


what is difference between WEBi Report and Crystal Report?

3 Answers   Cognos, Nucleus Software, Red Cross,


Explain about a tricky situation for which you found a very simple solution?

0 Answers  


can i link two Universes having with different connection

3 Answers  


what is the use of merge option in webi reports? explain with example?

2 Answers   TCS,


IN BO I HAVE DATASOURCE HAVING THE DATA LIKE "abc" and after creating the Report that is unmathed data like "DEF".what will you do ?

3 Answers   Accenture,


Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu

2 Answers   Infosys,


What is meant by ZABO and FC(full-client)?

2 Answers  


Any body help me...what are challenges did u face in Business object project?

1 Answers  


What is a fantrap in business objects?

0 Answers  


Categories