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

Answers were Sorted based on User's Feedback



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

Answer / jaimeen shah

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

Swetha is wrong because we can use joiner transformation,
we can join the sources from the same data source.

Is This Answer Correct ?    9 Yes 2 No

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

Answer / swetha

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.

Is This Answer Correct ?    5 Yes 6 No

Post New Answer

More Informatica Interview Questions

How to use Normalizer transformation?

2 Answers  


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

0 Answers  


WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 Answers  


design of staging area?

0 Answers  


can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,






Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva

1 Answers   Accenture,


how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,


When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

0 Answers  


Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,


What is the difference between source qualifier transformations source filter to filter transformation?

0 Answers  


how to read data from website into informatica? plsss send answers ASAP thanks in advance.

1 Answers   DELL,


Categories