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
- 4848 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How would you join a node to the already existing domain?
Can anyone tell me the new features in Informatica 9 Version?
What is a mapplet/worklet in informatica?
Explain the types of lookup transformation?
How do you convert single row from source into three rows into target?
is it possible to index the data in cache of lkp transformation ?
What is a rank transform?
Please let me know how to make Data masking in informatica..
What does role playing dimension mean?
How to convert multiple rows to single row (multiple columns) in informatica
Enlist the tasks for which source qualifier transformation is used.
What is a sequence generator transformation?
What are session parameters ? How do you set them?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Explain the aggregator transformation?
