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
- 4852 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 |
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
what is filelist concept in informatica
when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
What are the data movement modes in informatica?
What are the parts of Informatica Server?
how can u load the data in time dimension?
How does the server recognize the source and target databases. Elaborate on this.
What is the meaning of up gradation of repository?
What are some examples of informatica etl programs?
how can u tune u r informatica mapppings
what is informatica metadata?
What do you understand by term role-playing dimension?
Teradata 
