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


Please Help Members By Posting Answers For Below Questions

What are the types of Data Warehouse applications?

515


What is the difference between project backlog and product backlog?

1028


how do u handle performance issues in Informatica . where can u monitor the performance ?

4268


if i have a query as flat file how can we load data to target table

974


what is Forward,Reverse and Re_engineering?

1728






what is the main role of FI on business

1627


What are snapshots?

540


Explain me ETL project architecture in Detail?

1924


What is etl process?

536


What is grain of fact?

544


Compare ETL & Manual development?

554


Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

1813


Define slowly changing dimensions (SCD)?

615


Define Dynamic push down optmization?

1910


What is Data Vault???

2344