I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK
AND DATE VALIDITAION LOAD TO TARGET TABLE
code should be like this:
Check whether the pk is present, if present, its a duplicate record.
then check for the null values
then check for invalid date columns
iif(not isnull(pk),error_code_dup_rec,
iif(isnull(col1)
or (is null(col2),null_value_
present,
or is null(date),invalid_date,valid_record))
Is This Answer Correct ? | 1 Yes | 1 No |
How to provide security in frame work manager for a query subject?
State any 5 of Cods guidelines of an OLAP system, brief description each?
What are the advantages of cold fusion?
What is a view as it relates to system modeling?
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?
Explain the different types of data warehousing?
Data WareHousing course in noida
What is the main difference between schema in rdbms and schemas in datawarehouse?
Can you state some of the innovations throughout history?
Explain me what are conformed dimensions?
Whether dimension table can have numeric value?
What is cost benefit analysis (cba)?