I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK
AND DATE VALIDITAION LOAD TO TARGET TABLE
- 1 Answers
- 5110 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 |
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
What are the different types of Fatcs? Explain with example only
How do you define data block size?
Best institute for MS BI training in Hyderabad, India?
what are the types of dimension tables
How to answer the question how many fakt table in your datawarehouse and what size it have?
What is the working process for application.cfm?
Explain the differences between normalizer and normalizer transformation?
Explain me what are conformed dimensions?
Explain the definition of normalized and denormalized view and what are the differences between them?
Explain ddl (data definition language)?
What are the differences between star and snowflake schema?
Teradata 
