Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / priyank
First of all union transformation allows duplicate ddata to
pass through. Now say we have n input groups and there are
m records coming from them. In the output group all the m
records will go through.
For a transformation to be an Active transformation, it has
to satisfy either of the below 3 conditions:
1. no of i/p <> no of o/p
OR
2. row type of the input row changes.
OR
3. Transaction scope of the input rows changes.
For union transformation as discussed above , it satisfies
the 1st and the 2nd condition. But the order in which the
input is passed through the union transformation is not
fixed as in the first record to pass through the
transformation can be from the nth source and the last
record can be from the 1st source. So here the transaction
scope of the input rows changes and hence Union
transformation is an Active transformation.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How would you copy the content of one repository to another repository?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is the use of target designer?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is aggregate cache in aggregator transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
Explain the mapping variable usage example in informatica
How we can create indexes after completing the loan process?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Explain why we use partitioning the session in informatica?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are ETL Tools?
Can we create multiple integration service on single repository?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Describe an informatica powercenter?
