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
- 3991 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
Explain the shared cache and re-cache?
which one is better performance wise joiner or look up
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Explain how many types of dimensions are available in informatica?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are the different types of transformation available in informatica.
How to extract the informatica rejected data?
Can we create multiple integration service on single repository?
What are the different transaction levels available in transaction control transformation?
what is the Default Source Option For Update Strategy Transformation?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How can informatica be used for an organization?
What is lookup transformation?
