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?
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 |
Describe the impact of several join conditions and join order in a joiner transformation?
what happens if you try to create a shortcut to a non- shared folder?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.
how to sort date field in infomatica?
empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.
how DTM buffer size and buffer block size are related
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What are 2 modes of data movement in Informatica Server?
What is a rank transform?
Clarify the aggregator change?
What is the Difference between sorter and aggregator?