why union transformation is active transformation?
Answer Posted / venkateshmalneni
If the source1 has 10 records and the it contains 3 records
and the same 3 records are in the second source,the second
source contains 10 records if we want to join them using union
t/r then the output is 17 records instead of 20 records.
thats why we say that UNION T/R is active t/r
| Is This Answer Correct ? | 3 Yes | 32 No |
Post New Answer View All Answers
Explain what is informatica metadata and where is it stored?
In warehouses how many schemas are there?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
is it possible to index the data in cache of lkp transformation ?
How to elaborate powercenter integration service?
How to configure mapping in informatica?
Which transformation should we use to normalise the COBOL and relational sources?
What are the limitations of joiner transformation?
Why sorter is an active transformation?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
State the limitations where we cannot use joiner in the mapping pipeline?
Make a note of the quantity vaults made in informatica?