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 |
Difference between Microstrategy and Hyperion if any one Knows kindly updated me my dear Friends
What is dimension modeling?
Could any one explain me how to create cascading prompts?
Explain what are the various reporting tools in the market?
What is a view as it relates to system modeling?
Explain the different types of data warehousing?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain reference cursor?
What is metadata in context of a datawarehouse and how it is important?
where exactly in dataware house a confirmed dimension can be created
What is the difference between agglomerative and divisive hierarchical clustering?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?