top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

Compare Keys in Informatica

+2 votes
45 views

I am trying to solve an Informatica problem

I have two tables: Table A and Table B have the following structure

Table A
A_Key
A_Name
A_Address

Table B
B_Key
B_Name
B_Address
A_Key (Foreign Key)

I need to make sure that Every A_Key in Table B exist as A_Key in Table A.

Since I am new to Informatica Data Quality tool, I am trying to find the logic how I can implement this.

One logic that I can think is creating Rule

Does anyone have a better solution?

posted Apr 21, 2014 by Rohini Agarwal

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

0 votes

You can implement a joiner between Table B (as master) and Table A (as detail), the joiner type must be detail outer, so you will get all rows in table B and their equivalent in table A. Then you could obtain those rows in table B wich doesn't have an equivalent in Table A using a filter transformation. And finally you can count the rows using an aggreation transformation.

Table A

  Joiner A-B   --- Filter (a is null) -- Agregator (count rows)

Table B

answer Apr 22, 2014 by Shweta Singh
Similar Questions
+1 vote

SQL SERVER 2014 SSIS has been released,we have already got lot of facilities in SQL SERVER 2012 SSIS.Can anybody compare SSIS 2014/SSIS2012 with Informatica Power center ? What are the additional fetures are there in the Informatica new version than SSIS 2012/2014? Or are there functions in SSIS 2014/20122 ,which are not available in Informatica.

+1 vote

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

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...