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 |
Two different admin users created for repository are________and_________.
if u can't find what you are looking for in lookup table, how do you handle?
how do u extract data from different data sources explain with an example?
IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.
What is virtual Data Warehousing?
Explain about the data integration suite features?
how to answer the question "explain project architecture" in informatica pls any one who has the answer pls send the answer to this mail id "karumanchisrinu@gmail.com
what is the difference between cubes and package in cognos
how do u really know that paging to disk is happening while u are using a lookup transform?
what happens if the info.server doesn't find the session parameter in the parameter file?
what is session partitioning?
What is staging area referring to?