Hello Guys, today I am going to explain about Union Transformation and how it is working while both sources are different.
What is Union: Union is a set operator in oracle by using this we can combine the different queries.
Scenario: Here I'm going to combine the data from a Flat File and a Oracle Table which are having the same structure.
Step 1: Here I consider the EMP table as Oracle table, so we need to create the Flat file(*.CSV) which having the same structure as oracle table.
Step2: Now import both flat file and oracle table as Source by using informatica source analyzer.
Step3: Create a new mapping by using mapping designer. And then please drag both sources from source folder.
Step4: Now create a union transformation, after that create 2 new groups as we are going to union two sources. As shown in below.
After this now you are able to see 2 input groups and 1 output group. Please find the below screenshot.
Step 5: Now we need to drag the Columns from Flat File source qualifier to Union Flat File group and then drag the columns from Oracle Table SQ to Union Database table group. Then Connect the Union transformation output ports to target.
Please create the session and run the workflow.
Still if you are getting any issues please let me know.
If you need Mapping XML, do comment here or please send a mail to me.
You may also interested in below SQL logic.
Convert one row into multiple rows using SQL transformation.
What is Union: Union is a set operator in oracle by using this we can combine the different queries.
Scenario: Here I'm going to combine the data from a Flat File and a Oracle Table which are having the same structure.
Step 1: Here I consider the EMP table as Oracle table, so we need to create the Flat file(*.CSV) which having the same structure as oracle table.
Step2: Now import both flat file and oracle table as Source by using informatica source analyzer.
Step3: Create a new mapping by using mapping designer. And then please drag both sources from source folder.
Step4: Now create a union transformation, after that create 2 new groups as we are going to union two sources. As shown in below.
After this now you are able to see 2 input groups and 1 output group. Please find the below screenshot.
Step 5: Now we need to drag the Columns from Flat File source qualifier to Union Flat File group and then drag the columns from Oracle Table SQ to Union Database table group. Then Connect the Union transformation output ports to target.
Please create the session and run the workflow.
Still if you are getting any issues please let me know.
If you need Mapping XML, do comment here or please send a mail to me.
You may also interested in below SQL logic.
Convert one row into multiple rows using SQL transformation.
