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
- 1 Answers
- 5787 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
What are aggregate fact tables ? why they are needed? give an example
What is prompt types of prompts?use of prompts syntax of prompt?
Do you view contain data?
What are the tools available for etl?
What is the purpose of cluster analysis in data warehousing?
What is a view as it relates to system modeling?
How to know the time taken for particular report execution?
How can Oracle Materialized Views be used to speed up data warehouse queries?
Explain what is cost benefit analysis (cba)?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
What is conformed fact?
How to improve session performance in aggregator transformation?
Teradata 
