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 |
Give some difference between oltp and olap.
What is DTS ?
What are the types of partitioning?
In datastage can ve find the job based on source table name ??
After the complete generation of a report who will test the report and who will analyze it?
Explain in detail abt measure objects? And what is the use of it? How to create it?
What are templates in which way it is help full?
What are loops in Datawarehousing?
if you use oracle sql*loader , how do you transform data with it during loading?
How many ways we test the universe & Report?
can anybody mail me the FAQS for hyperion essbase amd planning
How to create prompts in report net?