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 session partitioning?
What is etl process? How many steps etl contains?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
Explain and compare etl & manual development?
what is pmrep command?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you
what is the difference between cardinality and Nullability?
how would u estimate the size of Lookup transform data and index cache?
what is the difference between normal & bulk loading? and which one is recommended ? why?
Difference between flat files and relational sources?