Informatica target table populating

Question

I am new in Informatica,here i am trying to populate my target table by joining two tables where the no. of rows in both the table is 5649 and 2611 respectively.So, my output rows should be 8260.But the no. of rows rows in target table is around 108860 (approx.).

Why this is happening and how should I remove it?

Are you sure you want to "join" the tables ? From the sound of it, looks like that you are trying to achieve is a "stich" or union, wherein the data from one attaches itself to the other table... please clarify with some examples here.. — Raghav
The join is not based on unique Keys. So, whats happening is non key join and it is resulting multiple rows. For example, if one table has values like a1, a1 and second table has values like a1,a1,a1. You expect 2/3 records as output, but you will get 6(3x2). — Koushik

Marek Grzenkowicz Marek Grzenkowicz · Accepted Answer · 2012-11-19T10:02:19

It seems to me that you are confusing the join operation with union.

You need to merge two sets of rows into one, so use a Union transformation, not a Joiner.

Informatica target table populating

2 Answers