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.
1) Differences between DSS and OLTP.2) Explain Grouped cross tab.3) Define Surrogate key.4) What is IQD file.5) Expalin Reference cursor.
Latest Answer: Method 1 is system develope lifecycle create by arthur anderson a while back. ...
Latest Answer: Data analysis explains the overall performance of a business organization data can be analyzed based on the ETL tools operations like informatica, data staging...) and the reports generated by the OLAP ...
What is system conversion? For example, if Bank do system conversion, what does that mean? What are steps to do successful system conversion?
1) what is datawarehouse architecture?2) Informatica Architecture?3) what is unit testing?4) what is type2 version dimension?
Latest Answer: for a faster process create aggregate tables and write better sql so that the process would fast ...
View page << Previous 2 3 4 5 [6] 7 8 9 10 Next >>

Go Top