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
- 8993 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 is scope of analysis ?
What is ment by For each For all function. In which case we use the option in BO?
What is the difference between slice and dice and cross tab report?
3.what is alias?
5 Answers Business Intelligence Analytics, TCS,
How to create predefined filters in B.O.
When upgrading from 3.1 to 4.0. Which services need to run ONLY? Do ALL services need to be running?
what is a filter?
What is Complex Reports?
How we can resolve the loops by using the Aggrigate Awareness?
can we create aliases for every table beforehand? if yes whar are the disadvantages?
WHAT IS THE DIFF BETWEEN BO6.5 AND BOXI
how many reports have u created ? explain a few.
0 Answers Bank Of America, TCS,
Teradata 
