what is diffrence b/w joner and union transfermation

Answer Posted / ashu alle

joiner transformation supports homogenious and
heterogenious data..

union transformation supports only heterogenious data

Is This Answer Correct ?    1 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2408


What if the source is a flat-file?

697


how we can load rejected record's at run time?(not through bad files)

2011


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1978


How would you copy the content of one repository to another repository?

651






What is a snowflake schema?

655


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2180


Describe an informatica powercenter?

714


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

753


What is the way to execute pl/sql script using informatica mapping?

1083


What are the popular informatica products?

720


Why sorter is an active transformation?

840


can we override a native sql query within informatica? Where do we do it? How do we do it?

709


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1735


Please let me know how to make Data masking in informatica..

1343