What is the main difference between a Joiner Transformation
and Union Transformation?

Answer Posted / ash.gadgi

Joiner Transformation merge horizontally

Union Transformation merge vertically

Is This Answer Correct ?    13 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of presistent cache in look up tr.

1672


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

673


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1751


Enlist the tasks for which source qualifier transformation is used.

669


Where are the source flat files kept before running the session?

721






Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

892


How do you change a non-reusable transformation to reusable transformation?

691


How to open an older version of an object in the workspace?

716


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

817


differences between service based and product based?

1655


What do you mean incremental aggregation?

716


Where is metadata stored?

701


-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?

5141


Separate from an archive server and a powerhouse?

579


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1628