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
5678 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

What are the mapping paramaters and maping variables?

975

Explain what are the modules in power mart?

971

What are algorithms provided by Microsoft in SQL Server?

1981

Explain what is the main difference between inmon and kimball philosophies of data warehousing?

920

Describe the differences between a data warehouse and data mart.

924

Why we use repository connectivity?

922

What is the difference between connected and unconnected stored procedures?

986

The same tier?

979

How can we schedule the graph in unix?

932

What function should we use to display the value entered or selected by a user in response to a prompt?

921

Explain me what are conformed dimensions?

948

How to join 3 database like flat file, oracle, db2 in informatrica?

1124

What are vaious etl tools in the market?

938

What is recovering sessions?

872

Why denormalization is promoted in universe designing?

943