without using ETL tool can u prepare a Data warehousing and
maintaining?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / zak
Theoritically speaking Yes. Preparing a Datawarehouse and
maintaining will only be feasible when the amount of Data
you are dealing with is small. Practically Datawarehouses
will have huge data with large number of tables and complex
business rules which may keep changing from time to time.
All this makes practically impossible to implement DWH just
by writing database queries.
Is This Answer Correct ? | 1 Yes | 0 No |
what is the advantage of persistent cache? when it should be used?
Eliminating of duplicate records without using dynamic lookups
what is the difference between OLTP database and data warehousing database?
what is the difference between shortcut of an object and copy of an object? compare them?
what are the data modeling tools you have used?(polaris)
how do u implement configuration management in Informatica?
Explain about round-robi?
how to connect to a flatfile through ftp in informatica
What are the modules in Power Mart?
What are the differences between sql override and update override?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.