I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK
AND DATE VALIDITAION LOAD TO TARGET TABLE
- 1 Answers
- 5106 Views
- Wipro, I also Faced
- E-Mail Answers
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 the difference between power center & power mart?
Suggest a good author for hyperion in data warehousing?
What are the design methods of data warehousing?
What is a relationship?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What are the data types present in bo?
Explain what is analytical or analytic mean?
a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron
How to create prompts in report net?
What are session timeout and application timeout? Where we have to do this process?
ware house management system is used?
How to calculate fact table granularity?
What are steps we have to follow in designing the userfriendly universe?
What is hybrid slowly changing dimension?
How can you clear the cache?
