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

Informatica - How Union Transformation is an Active Trans?




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

How Union Transformation is an Active Trans?


           

1 Answers



 
answered By vishnoiprem   0  
Union Transformation is active, because
When u configure a session using update strategy the session property data driven instructs informatica server
to use the instructions coded in mapping to flag the rows for insert, update, delete, this is the default option selected when using a update strategy transformation in a mapping.
 
Union transformation is developed using the Multigroup External Procedure transformation which is an active transformation

The following can be done with the union transformation!
 
Source
Col1    Col2
A    A
B    B
 

Target
Out_Col
A
B
A
B
 
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