Informatica - In which condtions we can not use joiner transformation(Limitaions of joiner transformation)?

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 37 of 630

In which condtions we can not use joiner transformation(Limitaions of joiner transformation)?

Both pipelines begin with the same original data source.
Both input pipelines originate from the same Source Qualifier transformation.
Both input pipelines originate from the same Normalizer transformation.
Both input pipelines originate from the same Joiner transformation.
Either input pipelines contains an Update Strategy transformation.
Either input pipelines contains a connected or unconnected Sequence Generator transformation.

Total Answers and Comments: 9

Last Update: November 24, 2007

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

January 25, 2006 12:18:35

Surendra

RE: In which condtions we can not use joiner transform...

This is no longer valid in version 7.2

Now we can use a joiner even if the data is coming from the same source.

Is this answer useful? Yes | No

March 30, 2007 14:40:18

kanak3

Member Since: November 2005 Contribution: 4

RE: In which condtions we can not use joiner transform...

You cannot use a Joiner transformation in the following situations(according to infa 7.1):
♦Either input pipeline contains an Update Strategy transformation.
♦You connect a Sequence Generator transformation directly before the Joiner
transformation.

Is this answer useful? Yes | No

April 03, 2007 07:55:24

Vaibhav

RE: In which condtions we can not use joiner transform...

I don't understand the second one which says we have a sequence generator? Please can you explain on that one?

Is this answer useful? Yes | No

April 07, 2007 11:02:35

swapna

RE: In which condtions we can not use joiner transform...

Can you please let me know the correct and clear answer for Limitations of joiner transformation?

swapna

Is this answer useful? Yes | No

April 07, 2007 21:06:48

kanak3

Member Since: November 2005 Contribution: 4

RE: In which condtions we can not use joiner transform...

You cannot use a Joiner transformation in the following situations(according to infa 7.1): When You connect a Sequence Generator transformation directly before the Joiner transformation.

for more information check out the informatica manual7.1

Is this answer useful? Yes | No

July 09, 2007 10:12:50

Saurabh

RE: In which condtions we can not use joiner transform...

What about join conditions. Can we have a != condition in joiner.

Is this answer useful? Yes | No

July 22, 2007 14:09:22

utsav mamoria

RE: In which condtions we can not use joiner transform...

No in a joiner transformation you can only use an equal to (=) as a join condition
Any other sort of comparison operators is not allowed

>,<,!=,<> etc are not allowed as a join condition

Utsav

Is this answer useful? Yes | No

August 18, 2007 04:29:58

vineela

RE: In which condtions we can not use joiner transform...

Yes, joiner only supports equality condition

The Joiner transformation does not match null values. For example, if both EMP_ID1 and EMP_ID2 from the example above contain a row with a null value, the PowerCenter Server does not consider them a match and does not join the two rows. To join rows with null values, you can replace null input with default values, and then join on the default values.

Is this answer useful? Yes | No

November 05, 2007 14:13:28

divakar

RE: In which condtions we can not use joiner transform...

We cannot use joiner transformation in the following two conditions:-

1. When our data comes through Update Strategy transformation, or in other words after Update strategy we cannot add joiner transformation
2. We cannot connect a Sequence Generator transformation directly before the Joiner transformation.

Is this answer useful? Yes | No

Go To Top