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


Please Help Members By Posting Answers For Below Questions

What are snapshots?

540


what is granularity in Data ware House?

1165


what is pmrep command?

1949


what is an ETL or ETT? And what are the different types?

6928


What is etl process?

538






What is a lookup table in etl?

598


What is virtual Data Warehousing?

552


flat filevalidation in informatica

1743


what are the concerns of OLTP and DSS systems?

1973


can be used COM component in Informatica ?

1615


Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

3318


how do u really know that paging to disk is happening while u are using a lookup transform?

2045


how to load the data to fact table?

2153


What are the three tiers in etl?

593


what is the meant by Normalization and de-normalization?

2237