without using ETL tool can u prepare a Data warehousing and
maintaining?
Answer Posted / 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 |
Post New Answer View All Answers
Can we create Hierarchies in generic datasources?
what is dynamic insert?
What is etl process? How many steps etl contains?
In Which Transformation We Can Use Having Clause In Informatica?
how do u really know that paging to disk is happening while u are using a lookup transform?
Explain etl mapping sheets?
how would u estimate the size of Aggregator transform data and index cache?
What is a mapping?
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.
explain the methodology of Data Warehousing?(Polaries)
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?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
Explain about power designer data modeling software?
what is data modeling?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?