Interested to Buy Any Domain ? << Click Here >> for more details...
without using ETL tool can u prepare a Data warehousing and
maintaining?
- 3 Answers
- 7998 Views
- I also Faced
- E-Mail Answers
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 |
flat filevalidation in informatica
how would u estimate the size of Lookup transform data and index cache?
what are the data modeling tools you have used?(polaris)
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
where are the log files generally stored.Can you change the path of the file.what can the path be?
what is pmrep command?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
What do you understand by active and passive transformations?
Compare etl & elt?
what are Lookup caches options? Including persistent caches.
what are the reports developed in sap bw project and what is the requirement for developing it?
dimension object created in oracle can be imported in designer?how?
Teradata 
