Interested to Buy Any Domain ? << Click Here >> for more details...
without using ETL tool can u prepare a Data warehousing and
maintaining?
- 3 Answers
- 8273 Views
- I also Faced
- E-Mail Answers
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
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.
Explain about round-robi?
Compare ETL & Manual development?
What are dimensions?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
Two default user groups created in the repository are____and_____.
What is full load & incremental or refresh load?
What is a staging area? What is the purpose of a staging area?
What are materialized views & where do we use them?
what is Forward,Reverse and Re_engineering?
How to increase performance without changing anything in mapping.( In prod)
Difference between flat files and relational sources?
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
how do u really know that paging to disk is happening while u are using a lookup transform?
what is dynamic insert?
