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 |
What are the advantages of cold fusion?
What are universe requirements?
How to drill through from a powerplay cube to reportnet?
What we will do with the universe for faster process?
What is data warehosuing hierarchy?
What is Star Schema?
Explain the differences between normalizer and normalizer transformation?
Explain how many ways you create ports?
Explain what is the advantages data mining over traditional approaches?
can anybody mail me the FAQS for hyperion essbase amd planning
Explain which are the olap tools available that are supported by oracle?
Explain about core dimension,