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
- 5770 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 difference between view and materialized view?
What are the differences between datamart vs. Reporting cube?
What is DTM session?
Explain what is analytical or analytic mean?
How to generate iqd file from framework manager?
What is your spectra photometer working principles?
Can you pass sql queries in filter transformation?
Explain what are non-additive facts?
Explain what are the basic needs to join two sources in a source qualifier?
Explain why dimenstion tables are denormalized in nature?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
What is a view as it relates to system modeling?
Teradata 
