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
What are the types of presistent cache in look up tr.
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??
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
Enlist the tasks for which source qualifier transformation is used.
Where are the source flat files kept before running the session?
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.
How do you change a non-reusable transformation to reusable transformation?
How to open an older version of an object in the workspace?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
differences between service based and product based?
What do you mean incremental aggregation?
Where is metadata stored?
-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?
Separate from an archive server and a powerhouse?
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