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
- 5852 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 |
The same tier?
What is data stream and data adaopter. Is it same are different? Explain?
Explain in detail abt measure objects? And what is the use of it? How to create it?
Explain the difference between oltp and olap?
Explain the hierarchies level data warehousing.
What is the advantages data mining over traditional approaches?
What are the stages that are required in data warehousing?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
What is called data cleaning?
difference between bo 6.5 and bo xi r2
What is the use of incremental aggregation? Explain me in brief with an example?
What is META DATA information in Data warehousing projects?
Teradata 
