two tables from two different databases r there . both
having same structure but different data . how to compare
these two tables ?
- 10 Answers
- 23351 Views
- HP, Patni, I also Faced
- E-Mail Answers
Answer Posted / shobana
Joiner transfomation is used to join two differned soures
from the same database. Lookup transformation and
expressions(if needed) can be used to compare data from two
different two differebt types of sources.
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What are mapplets? How is it different from a Reusable Transformation?
How can you differentiate between powercenter and power map?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How do you set a varible in incremental aggregation
What is mapplet in informatica?
Explain what are the different versions of informatica?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How do you change a non-reusable transformation to reusable transformation?
What is mapping debugger?
Explain the etl program with few examples.
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 is INFORMATICA TESTING process
On which transformations you created partitions in your project?
Differences between version 7.x and 8.x.
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
