without using ETL tool can u prepare a Data warehousing and
maintaining?
Answer Posted / bharathikmylearningsphere
Yes , it is possible to create a datawarehouse without
using ETL tool. but it will be very very complicated and
time consuming and if the needs change you need to re-work
on it again.but when you use etl tools you can adapt you
can make the changes as required.
Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
Explain what is etl process? How many steps etl contains explain with example?
What is partitioning? Explain different types of partitioning?
What is etl tool in hadoop?
What is a lookup table in etl?
What is etl process. How many steps etl contains explain with example?
What are the differences between sql override and update override?
Explain about etl data integration software?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
can be used COM component in Informatica ?
Is hadoop a etl tool?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
How many types of transformations supported by sorted input?
Can there be sub steps of etl steps?
When do we analyze the tables?
What are your responsibilities as an etl tester?