CODEWITHSUNDEEP
informatica-powercenterjoiner
ASHISH GUPTA
ASHISH GUPTA

Reputation: 61

Not allowed to use Joiner transformation

I have an expression transformation from which I am passing the data to two different transformations.

Later in the downstream of these parallel flows, I am trying to apply a joiner transformation but I am not allowed to do so.,

Is joiner transformation not allowed in a such a case similar to self-join? What could be an alternative approach if I wanted to achieve such a transformation?

It would be great if somebody can help me sort out this issue.

Upvotes: 0

Views: 880

Answers (2)

Nimisha
Nimisha

Reputation: 80

Joiner Transformation will work. I assume the if the data is from same source table and is passed through different pipe line, use the option of SORTED INPUT in the joiner transformation.

Upvotes: 0

Lars G Olsen
Lars G Olsen

Reputation: 1118

You need to sort the data before the joiner, and turn on 'sorted merge join' before connecting the second set of ports to the joiner.

One voice of caution though: carefully consider the 'key' you join these data on. I should be a unique value across all records on at least one of the two data streams, otherwise you'll end up with a data explosion. I know this may sound very basic, but it is often forgotten in self joins :)

Upvotes: 0

Related Questions