CODEWITHSUNDEEP
informatica-powercenterinformatica
coolmego
coolmego

Reputation: 155

Informatica target table populating

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?

Upvotes: 0

Views: 1017

Answers (2)

Aswin
Aswin

Reputation: 111

if table structure isn't same pick/select only common columns and then perform a union in SQ Override..

Upvotes: 0

Marek Grzenkowicz
Marek Grzenkowicz

Reputation: 17353

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.

Upvotes: 1

Related Questions