What is ETL process in Data warehousing?
Answers were Sorted based on User's Feedback
Answer / siri
ETL means extraction,transformation and loading.i.e
extracting the data from different data bases and
transforming it depending on our requirements then finally
load it into warehouse.
| Is This Answer Correct ? | 50 Yes | 4 No |
Answer / ramjanaki
ETL Process can be defined as the Extraction of Information
from various sources like flat files, databases or XML
data, Performing transformations (manipulations on the data)
based on the user requirements and loading them to the
Target location.
| Is This Answer Correct ? | 29 Yes | 3 No |
Answer / ravi rajak
ETL means extraction,transformation and loading.It means extracting the data from the heterogeneous sources and after that transform that data into same format is transformation and and then we load that data into the datawarehouse is loading.
| Is This Answer Correct ? | 7 Yes | 6 No |
The same tier?
What is Snow Flake Schema design in database?
When should you use a STAR and when a SNOW-FLAKE schema?
What is prompt types of prompts?use of prompts syntax of prompt?
What is meant by metadata in context of a data warehouse and how it is important?
What is aggregate fact table?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
Explain functional dependency?
What is a functional dependency f said to be minimal?
Difference between slicing and dicing with example?
What is the difference between constraind base load ordering and target load plan?