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?



SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name i..

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

Post New Answer

More Informatica Interview Questions

Describe the impact of several join conditions and join order in a joiner transformation?

0 Answers  


what happens if you try to create a shortcut to a non- shared folder?

1 Answers  


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,


Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  


how to sort date field in infomatica?

2 Answers  






empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.

3 Answers  


how DTM buffer size and buffer block size are related

3 Answers   Wipro,


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

0 Answers   CTS,


What are 2 modes of data movement in Informatica Server?

1 Answers   Informatica,


What is a rank transform?

0 Answers  


Clarify the aggregator change?

0 Answers  


What is the Difference between sorter and aggregator?

2 Answers  


Categories