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 difference between OLTP database and data warehousing database?
CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"
What is the difference between Data Warehousing and Data Mining?
What are the ETL Testing Operations?
What is etl process? How many steps etl contains?
How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?
how do use session mapping parameters ?(in which transformation)
Eliminating of duplicate records without using dynamic lookups
What is ROWID explain ?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
what happens if the info.server doesn't find the session parameter in the parameter file?