Union Transformation is used to combine or merge multiple sources having same structure and data types. if I combine 2 sources one having 10 records and another having 10 records and the output is 20. so here input and output record is same. then why should we call Union is Active. need a example for this
Why union Transformation is Active?
372 Views Asked by nithin At
1
There are 1 best solutions below
Related Questions in INFORMATICA
- PWX-00001 Error opening repository "dtlmsg.txt". RCs = 268/150/2
- Expression to replicate Aggregator
- rep_1235 this object has been modified since the time it was read
- Converting LONG to CLOB in INFORMATICA
- jar file execution through informatica java trasformation
- i have headers separately, how to import it to informatica target
- Shell Script to Validate Filename
- How to perform binary data comparison in Informatica Power Center
- using http link in informatica power center
- Executing PMCMD command from JAVA Client
- Excel Macros on Informatica
- Is there a way to avoid the target table in informatica (powercenter)?
- Getting Special character only in the "first column of first row" while loading to a text file using informatica
- how to add new line between header and data in flat file using informatica?
- ETL tool migration : Best Practices in Parallel Run
Related Questions in INFORMATICA-POWERCENTER
- PWX-00001 Error opening repository "dtlmsg.txt". RCs = 268/150/2
- Number of records using normal joiner in informatica
- jar file execution through informatica java trasformation
- •Informatica powercentre target xsd assistance
- How to perform binary data comparison in Informatica Power Center
- using http link in informatica power center
- Executing PMCMD command from JAVA Client
- Command-line Powercenter test tool
- ETL tool migration : Best Practices in Parallel Run
- Default join type in lookup transformation?
- Informatica Powercenter data truncation/overflow error
- Get max value of a column in my source table in Informatica
- Informatica: Delete rows from multiple tables sequentially. Then Insert
- Informatica shift field values to right
- what is difference between creating & running the workflow in client and server?
Related Questions in INFORMATICA-POWEREXCHANGE
- PWX-00001 Error opening repository "dtlmsg.txt". RCs = 268/150/2
- Informatica sorter transformation performance tunning related to cache allocation
- Informatica CDC Mapping: Group Source is fetching records Slowly
- How to do data masking for xmldatatype(oracle database) in informatica
- Informatica Powercentre not able to read messages from Kafka source topic. how to read Json message from Kafka topic in informatica powercentre?
- to find the highest sal employees and add only those employess in target by using IICS or informatica
- Informatica relational connection password change
- How to I execute part of a daily workflow only on Sundays
- Best Practice For updating Target Table In Informatica
- Create Amazon S3 target and load data from Oracle sources using Informatica powercenter
- Load Data into S3 with Informatica powercenter
- Download and install informatica for integrating it with hadoop
- need to load inserts before updates before deletes into target...data is all in one source
- Informatica jobs real time jobs from web-service
- Fetch the last modified date of all the workflow from the Repository using pmrep / pmcmd command
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Because if you consider the path from a single source to a single target then a UNION transformation between them can/will change the number of rows