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 ) ...
If you source data from a system that you (warehouse team) have no authority to enforce data quality at the source level, how do you handle this? Do you apply data validation just after you stage the data? Or do you enforce it at the “end” of the flow (typically as you’re pushing it into the data mart)? Or do you not enforce validation at all?
1)After the complete genaration of a report who will test the report and who will analyze it.2)After the genaration of a report to whom we have to deploy or what we do after the completion of a report.
View page << Previous 1 2 3 [4] 5 6 7 8 9 Next >>
Go Top
