SOURECE
Name id dept sal
1 a1 A 100
2 b1 B 200
3 c1 C 300
4 d1 D 400
TARGET:
Name id dept sal
1 a1 A 100
2 b1 B 200
3 WER1 567 300
4 d1 D 400
I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5
STEPS ABOVE TABLE?
- 1 Answers
- 4012 Views
- IBM, I also Faced
- E-Mail Answers
Answer / yash
There are many ways to check this:
1. Do Column level check meaning SRC.ID=TGT.ID but others
columns are not matching on data.
2. you can do MINUS (SRC MINUS TGT) and (TGT MINUS SRC)for
particular day's load.
3. you can do referential integrity check by checking any id
valus in SRC but not in TGT or any id in TGT but not in SRC.
Hope these are enough.
| Is This Answer Correct ? | 2 Yes | 2 No |
What are the Advantages of de normalized data?
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
Insert else update option in which situation we will use
what is shared Cache. when we will use shared Cache?
What is router transformation
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
what is diff b/t sorter t/r and agg have the option sorter property...
explain abt joiner t/r?
What is event and what are the tasks related to it?
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
What is the Rank index port in Rank transformation?
Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks
Teradata 
