Interested to Buy Any Domain ? << Click Here >> for more details...
I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK
AND DATE VALIDITAION LOAD TO TARGET TABLE
- 1 Answers
- 5697 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
Explain what are fact, dimension, and measure?
Explain what are the vaious etl tools in the market?
Best institute for MS BI training in Hyderabad, India?
After the complete generation of a report who will test the report and who will analyze it?
What is the difference between Datawarehouse and OLAP?
What are the other names given to data warehousing?
What is ?Data mining??
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
What is a linked cube?
Explain in simple terms, the concept of Data Mining.
What are non-additive facts in detail?
what is the difference between etl tool and olap tools
Teradata 
