What is a ETL/ How does Oracle support the ETL process?
Answer Posted / pradeeshkumar
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 |
Post New Answer View All Answers
Explain difference between snow flake and star schema.
What are the advantages of cold fusion?
What is data analysis? Where it will be used?
What is cfapplication tag?
Explain difference between view and materialized view?
Could any one explain me how to create cascading prompts?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
What is a relationship?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
Describe the differences between a data warehouse and data mart.
How to know the time taken for particular report execution?
What is data analysis?
What are the key features of chameleon that separates it from other algorithms?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What are templates in which way it is help full?