without using ETL tool can u prepare a Data warehousing and
maintaining?
Answer Posted / 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 |
Post New Answer View All Answers
What are the types of Data Warehouse applications?
In Which Transformation We Can Use Having Clause In Informatica?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
What is data cleaning?
What is staging area referring to?
what is the difference between cardinality and Nullability?
Explain about hash partitioning?
what are the concerns of OLTP and DSS systems?
Two default user groups created in the repository are____and_____.
What do you understand by the term ‘transformation’?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
how do u really know that paging to disk is happening while u are using a lookup transform?
Explain about round-robi?