Which of the following technology gives highest near real time ETL performance?Informatica RTAb Initio CFDatastage CDCSocket Programs
Data access includes all of the following EXCEPT1.Database middleware2.Multi-dimensional analysis3.Data mining4.Extensive metadata model
Latest Answer: Hi I believe that Dependent Dataware house are build on ODS. And Independent Dataware houses are real-time dataware having no dependency on any ODS systems. Regards,Ravi Kumar Garreravi_kumar_garre@yahoo.co.in ...
Latest Answer: STAR SCHEMA HAS fact table linked with dimension table directlywhile in snow flake schema the dimension tables can have futher hierarchies between them .it means in snow flake schema the tables are normalised.one shoula use star schema simply it is easy ...
Latest Answer: It is a column, which we when update the OLTP ...
Latest Answer: Use a bridge table.. as simple as that. ...
Latest Answer: cluster analysis is an exploratory data analysis tool which aims at sorting different objects into groups in a way that the degree of association between two objects is maximal if they belong to the same group and minimal otherwise ...
Latest Answer: Generation of CUBES is also a multiDimensional technique. You can reply if you are looking for more details.Regards,Ravi Kumar Garre ...
Latest Answer: we can not use sql queries in filter transformation.It won't allow you to override default sql query like other transformations( Source Qualifier, lookup ) ...
View page << Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>

Go Top