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
- Impact of PRE-SQL and POST -SQL on Push Down Optmisation in IICS
- Scheduling Informatica IICS taskflow
- Running 2 stored procedures in post SQL for Informatica
- Subtaskflow is getting suspended instead of failed in IICS
- Instr to find the exact pattern match in informatica
- Ho to change existing MD5 checksum value to make it different from previous value
- Informatica new line and carriage return
- Unable to read the JSON array element data from event based kafka topic message connection in IICS/IDMC
- REG_MATCH function in Informatica - Identify a pattern
- Return all records in Salesforce TASK table with Informatica
- Informatica Powerexchange post sql greenplum writer
- Replace SAS stored process with different ETL tool
- is there any open source tool to migrate informatica Etl Script to Aws glue?
- PMCMD Command to get session statistics Informatica
- how to handle chinese characters in teradata
Related Questions in INFORMATICA-POWERCENTER
- How to convert ansii file to utf-8 encoded file through informatica workflow?
- How to match the values generated by MD5 hash (Informatica) and Standard hash (Oracle)?
- Subtaskflow is getting suspended instead of failed in IICS
- Instr to find the exact pattern match in informatica
- Ho to change existing MD5 checksum value to make it different from previous value
- Informatica new line and carriage return
- Unable to read the JSON array element data from event based kafka topic message connection in IICS/IDMC
- Affected rows from seesion logs does not reflect in actual target table in Informatica
- Sequence-id in associated expression for dynamic lookup in Informatica Powercenter
- how to lookup on a table based on a null key in informatica powercenter
- PMCMD Command to get session statistics Informatica
- can we use informatica power center to load into teradata cloud?
- Informatica Incremental Load using greenplum writer
- How to call APIs in Informatica Powercenter
- how to create ETL to dynamically get the port name
Related Questions in INFORMATICA-POWEREXCHANGE
- Instr to find the exact pattern match in informatica
- Informatica new line and carriage return
- Informatica Powerexchange post sql greenplum writer
- Informatica Incremental Load using greenplum writer
- Informatica Powercentre not able to read messages from Kafka source topic. how to read Json message from Kafka topic in informatica powercentre?
- Cannot convert type string to date
- Informatica Incremental extract and load process
- Change Data Capture without the help of power exchange
- Running Postgres insert sql using command prompt informatica
- How to call a stored procedure in Pre-SQL using Informatica?
- How to handle improper Data Coming from CSV in Informatica
- Informatica PowerCenter [PERSISTENCEAPI_0307] [DBPERSISTER_2002] The Repository Service failed to create the repository content
- Oracle replace and translate command in IICS
- Processing excel files with many data in PowerCenter
- How to I execute part of a daily workflow only on Sundays
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 # Hahtags
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