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 columns go to the fact table and which columns go the dimension table?
What are algorithms provided by Microsoft in SQL Server?
three ways sql*loader could load data, what are those three types?
What is loop in data warehousing?
What are target types on the server?
What are the possible data marts in retail sales?
Explain what is a cube in data warehousing concept?
How can you define a transformation? What are different types of transformations in Informatica?
if we increase the number of dimensions will the rows in fact table increase or decrease??
What is the capacity of power cube?
How can Oracle Materialized Views be used to speed up data warehouse queries?
What are templates in which way it is help full?