Interested to Buy Any Domain ? << Click Here >> for more details...
What is a ETL/ How does Oracle support the ETL process?
- 1 Answers
- 4087 Views
- I also Faced
- E-Mail Answers
ETL stands for Extract transform and load.
In general the entire ETL process is only SQL scripts
executed against the database. Oracle being a Database
which favours ETL through SQL scripts.
| Is This Answer Correct ? | 1 Yes | 0 No |
Explain the difference between keylokup and joiner?
What is the difference between an ODS and a W/H?
Is it possible to have more than one row on the same table with the same foreign key?
What is data warehouse architecture?
What is a source qualifier?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
Explain what is the limit to the number of sources and targets you can have in a mapping?
What is Bulk Insert?
How do we design a universe?
Which columns go to the fact table and which columns go the dimension table?
Tell me one example for junk dimension?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
Teradata 
