code should be like this: Check whether the pk is present, if present, its

I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK
AND DATE VALIDITAION LOAD TO TARGET TABLE

Question Posted / itsranjan

1 Answers
5785 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

Please Help Members By Posting Answers For Below Questions

Explain the difference between data ware house & data mart?

963

What is crass reference table?

1061

Can we take backup when the database is opened?

1059

What are the other names given to data warehousing?

1098

What is the difference between power center and power mart?

1026

What is MODEL is Data mining world?

2624

Explain what is the difference between power center & power mart?

1003

What are the stages of datawarehousing?

1015

Suggest a good author for hyperion in data warehousing?

978

What are the steps to build the datawarehouse?

1040

What is a real-time data warehouse? How is it different from near to real-time data warehouse?

965

What are the possible data marts in retail sales?

1000

Explain what does level of granularity of a fact table signify?

961

Explain what is the limit to the number of sources and targets you can have in a mapping?

1005

What are the different types of schemas used in data warehousing?

956