Answer Posted / 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 |
Post New Answer View All Answers
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
Explain what are the various transformation available?
What is cubes?
How to create context?
Why is chameleon method used in data warehouse?
What are the reasons to use a chameleon method in data warehousing?
What are partition points?
What is difference macros and prompts?
What are the data types present in bo? What happens if we implement view in the designer n report?
I need to set predefined condition. How I do this?
Explain the difference between view and materialized view?
Explain what is the difference between power center & power mart?
Why null values are mapped as 0 in fact tables?
Explain what is the difference between olap and datawarehosue?
What is data type of the surrogate key?