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 |
we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??
What is etl process? How many steps etl contains?
what are Lookup caches options? Including persistent caches.
Identifying the bottlenecks in various components of Informatica and resolving them.
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.
What is granularity? Please explain with example
Explain about power designer data modeling software?
What is the main difference between peek stage and copy stage
Can u access a repository created in previous version of Informatica?
Explain etl mapping sheets?
explain the methodology of Data Warehousing?(Polaries)
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .