Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4920 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 |
How does a sorter cache works?
Explain dynamic target flat file name generation in informatica
What is CHECK-IN CHECK-OUT. Please explane me?
How do you load unique records into one target table and duplicate records into a different target table?
What are the various types of transformation?
Explain the different lookup methods used in informatica?
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
What are the different tools in workflow manager?
What are the advantages of informatica?
How to improve the performance of a session using sorter transformation?
Can anyone tell me the new features in Informatica 9 Version?
Teradata 
