Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



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

Answer / 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

More Data Warehouse General Interview Questions

What are the advantages of cold fusion?

0 Answers  


What are universe requirements?

0 Answers  


How to drill through from a powerplay cube to reportnet?

0 Answers  


What we will do with the universe for faster process?

0 Answers  


What is data warehosuing hierarchy?

0 Answers  


What is Star Schema?

0 Answers   Informatica,


Explain the differences between normalizer and normalizer transformation?

0 Answers  


Explain how many ways you create ports?

0 Answers  


Explain what is the advantages data mining over traditional approaches?

0 Answers  


can anybody mail me the FAQS for hyperion essbase amd planning

0 Answers   DataMonitor,


Explain which are the olap tools available that are supported by oracle?

0 Answers  


Explain about core dimension,

0 Answers  


Categories