what is diffrence b/w joner and union transfermation

Answer Posted / nagaraju bhatraju

joiner:
joiner doesn't require marching ports to join ,
both shoud be from heterogenious sources.


union:
union requires two flows with same no of columns and both
columns of the two flows orders should be same to produce
the combined flow .

Is This Answer Correct ?    18 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between sessions and batches?

545


What are the settings that you use to configure the joiner transformation?

588


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1680


What are the types of caches in lookup?

547


What is an Integration service in Informatica?

681






-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

4926


whats the logic to load the lower level of granularity of data to fact table.

1764


How to use procedural logic inside infromatica?

606


Is it possible to use a client with different version than that of its Informatica server?

614


Define enterprise data warehousing?

612


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

554


What is workflow manager?

552


How to Create a folder using pmrep command?

591


What is the need of an ETL tool?

616


What is rank transformation in informatica

659