Interested to Buy Any Domain ? << Click Here >> for more details...
without using ETL tool can u prepare a Data warehousing and
maintaining?
- 3 Answers
- 8150 Views
- I also Faced
- E-Mail Answers
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 |
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
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
How many steps etl contains explain with example?
what are Lookup caches options? Including persistent caches.
list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys
what are Lookup caches options? Including persistent caches.
what is the use of structures?how many nodes can u create in a structure?
how do u set partition points in the mapping?
What is etl process. How many steps etl contains explain with example?
how do u implement unconn.stored proc. in a mapping?
what is the meant by Normalization and de-normalization?
how do u automate Extraction process?
Teradata 
