what is the difference between etl tool and olap tools
Answer Posted / b siva pratap
etl tool means extract,transform and load the data into the
ware house.based on this data by using olap tool we can
generate reports
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What is metadata in context of a datawarehouse and how it is important?
Explain what are the basic needs to join two sources in a source qualifier?
What is the difference between snowflake and star schema?
What is data mart in data warehouse?
What is a real-time data warehouse?
What is the difference between olap and oltp?
How to eliminate duplicate rows from flat file?
What function should we use to display the value entered or selected by a user in response to a prompt?
What are non-additive facts in detail?
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.
How do you setup Lo-cockpit?
What is vdl (view definition language) explain?
What is factless fact tables?
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.
Explain why fact table is in normal form?