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
- 4736 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 is the command used to run a batch?
Which is the t/r that builts only single cache memory?
How will u find weather dimension table is big in size of a fact table?
Global and Local shortcuts. Advantages.
What is the functionality of update strategy?
how can we check whether a particular cache is static or dynamic?
what is difference between dimention table and fact table?
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
What is mapping debugger?
What are the databases that informatica can connect to windows?
Can i create a lookup table without cache.
Explain dynamic target flat file name generation in informatica
Teradata 
