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 |
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
what is the difference between MOLAP and ROLAP?
What is Grain & Granularity in Data Warehouse.
How do you setup Lo-cockpit?
What is the difference between agglomerative and divisive hierarchical clustering?
What is the goal of optimizer?
What is a data profile?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
How to provide security in frame work manager for a query subject?
How to use the tool Ontobulider
What is core dimension?
What is the differences between star and snowflake schemas?