two tables from two different databases r there . both
having same structure but different data . how to compare
these two tables ?

Answer Posted / janani

We can use lookup Transformation and expression to compare
the data

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is option by which we can run all the sessions in a batch simultaneously?

854


permutations of mapplet

2236


Differentiate between a repository server and a powerhouse?

767


Can u generate reports in Informatica?

815


wf dont have integration severances how you can run?

1700






Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6909


What are the conditions needed to improve the performance of informatica aggregator transformation?

797


write a query to retrieve the latest records from the table sorted by version(scd)

822


How to load the data from a flat file into the target where the source flat file name changes daily?

781


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

1888


What are the different lookup cache(s)?

801


differences between service based and product based?

1751


What do you mean incremental aggregation?

792


Explain informatica architecture - version 8 / 9

835


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1885