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
- 4916 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 can you validate all mappings in the repository simultaneously?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What are the types of data warehouses?
Differentiate between joiner and lookup transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How to handle decimal places while importing a flatfile into informatica?
How to open an older version of an object in the workspace?
What are session parameters ? How do you set them?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Mention few advantages of router transformation over filter transformation.
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Different circumstance which drives informatica server to expel records?
What is a joiner transformation?
What is main use of mapplet?
Explain the scenario which compels informatica server to reject files?
