I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK
AND DATE VALIDITAION LOAD TO TARGET TABLE
Answer Posted / itsranjan
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 |
Post New Answer View All Answers
Explain what is a view as it relates to system modeling?
Explain normalization?
What is metadata in context of a datawarehouse?
What is a functional dependency f said to be minimal?
What is a general purpose scheduling tool?
What is the difference between Datawarehouse and OLAP?
Compare cold fusion with other programming languages?
How to create different types of templates?
What are the different types of fact tables used in data warehousing?
Can we start and stop single session in concurent bstch?
Explain piconet?
What are the steps to build the datawarehouse?
What is factless fact tables?
Explain what are the tasks that loadmanger process will do?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?