Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - What are limitations of joiner transformation?




1533
views
asked marvit September 20, 2014 08:03 AM  

What are limitations of joiner transformation?


           

1 Answers



 
answered By Mswami   0  
Limitations of Joiner Transformation:

  •     You cannot use joiner transformation when the input pipeline contains an update strategy transformation.
  •     You cannot connect a sequence generator transformation directly to the joiner transformation.


Below are some other limitations 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.
  •     You cannot join more than two sources with a single joiner transformation.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert