I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK
AND DATE VALIDITAION LOAD TO TARGET TABLE
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
How to generate iqd file from framework manager?
Why should we use data ware housing and how can you extract data for analysis with example?
What are algorithms provided by Microsoft in SQL Server?
Explain how to generate iqd file from framework manager?
How can we determine what records to extract?
Explain how are the dimension tables designed?
How to export mappings to the production environment?
in general which algorithms for used?
Explain if a flat file cotains 1000 records how can I get first and last records only?
Explain difference between data ware house & data mart?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
Explain which are the olap tools available that are supported by oracle?
What are the different types of data warehousing?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is a data profile?