I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK AND DATE VALIDITAION

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

Question Posted / nagaraz

1 Answers
5677 Views
Wipro, I also Faced
E-Mail Answers

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

Post New Answer

More Data Warehouse General Interview Questions

What are snapshots? What are materialized views & where do we use them?

0 Answers

What is dimensional modelling?

0 Answers

Fact table is in normalized or de-normalized form?

0 Answers

Tell me the Top 10 features of oracle that supports datawarehousing.

2 Answers CTS, IBM,

What is Data purging?

8 Answers TCS,

hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

0 Answers L&T,

How to pivot row data using informatica?

0 Answers

Explain what are the different types of data warehousing?

0 Answers

What is Bulk Insert?

3 Answers

The same tier?

0 Answers

What is the very basic difference between data warehouse and operational databases?

0 Answers

explain about dirty dimension?

0 Answers

For more Data Warehouse General Interview Questions Click Here