Interested to Buy Any Domain ? << Click Here >> for more details...
What is ETL process in Data warehousing?
- 3 Answers
- 17075 Views
- I also Faced
- E-Mail Answers
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 |
How can we run the graph? What is the procedure for that?
What are the steps involved in designing a fact table?
What is surrogate key? Explain with examples.
What are the primary ways to store data in OLAP?
Name a few sectors which use data warehousing?
What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
What is drill-through?
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I
3 Answers IBM, Ness Technologies,
What is the difference between star and snowflake schemas?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Teradata 
