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?
- 3 Answers
- 9016 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What sort of existing documents should business analysts refer to when starting on a new project?
How would I achieve Traffic Lighting in Business Objects
what is variable ?
What is thumbnail?
9.what are the multidimensional analyses
1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?
can we use detail in generation of reports? if customer id is a dimension in a report, what will happen if we define it as a detail?
What is meant by multiple data provider.How to use it in universe as well as reporting environment?
what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
How do you restrict access to rows of a database?
Can anybody tell me the difference b/w canned and adhoc reporting?.
Teradata 
